Our example is shown in Figures 11, 12, and 13 below.įigure 13 Locate the David Kennedy record If there are multiple Kennedy records, click Find Next and Access will advance through the recordset until it finds all the matches. In our example, click on LastName then click Edit-Find to launch Find and Replace now type Kennedy and press Enter to have the Kennedy record automatically displayed. Type a phrase or just part of a phrase that is contained in the field. To initiate the Find and Replace dialog box, first click in the field you want to search through, then click Edit – Find using the menus at the top of the Access window. The second method is to use the Find and Replace dialog box. Of course, this is an inefficient way to find a record. You could click the next record button to advance to the next record, then the next, until you arrived at David Kennedy’s record.
The first method is to use the navigation buttons at the bottom of the form. You can follow along with this article by downloading the sample database. How would you locate his record? In this article we’ll review three methods available to find a record from within an Access form. Suppose you need to update the record for David Kennedy. For example, the Students Form shown in Figure 10 below, shows the first of 197 students contained in the students table.
0 kommentar(er)
