If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Find Specific Record using 2 controls
I know how to find a specific record using a combo box along with
GoToControl then FindRecord. I have set up a form and want to find a record by first and last name (which are in different fields). I can find by last name or first name but not both. As it is, when finding by last name, for example, it takes me to the first of that name i.e. the first "Alexander" and then I have to scroll through the records to the specific "Alexander" I want. Can anyone tell me how to set it up so I can go to the specific "Alexander" that I want. Thanks |
#2
|
|||
|
|||
I believe the simplist alternative will be to concatenate the LastName +
FirstName into one field that a combo box can display. Combo box to find a record http://www.access.qbuilt.com/html/find_a_record.html Tom _______________________________________ "timsken" wrote: I know how to find a specific record using a combo box along with GoToControl then FindRecord. I have set up a form and want to find a record by first and last name (which are in different fields). I can find by last name or first name but not both. As it is, when finding by last name, for example, it takes me to the first of that name i.e. the first "Alexander" and then I have to scroll through the records to the specific "Alexander" I want. Can anyone tell me how to set it up so I can go to the specific "Alexander" that I want. Thanks |
#3
|
|||
|
|||
If you have several "Jones, Alexander" entries in your table, then you are
going to have to use additional information in your search in order to move to a specific one. Access has no way of knowing which one you want unless you can choose some other identifying information. Larry Linson Microsoft Access MVP "timsken" wrote in message ... I know how to find a specific record using a combo box along with GoToControl then FindRecord. I have set up a form and want to find a record by first and last name (which are in different fields). I can find by last name or first name but not both. As it is, when finding by last name, for example, it takes me to the first of that name i.e. the first "Alexander" and then I have to scroll through the records to the specific "Alexander" I want. Can anyone tell me how to set it up so I can go to the specific "Alexander" that I want. Thanks |
#4
|
|||
|
|||
True, but you can always include additional columns in the combo box to help
identify which "Jones, Alexander" that you really want to select, in order to go to their record. For example, you can include the City & State, or some other information that allows you to uniquely identify the record. Tom ____________________________________ "Larry Linson" wrote: If you have several "Jones, Alexander" entries in your table, then you are going to have to use additional information in your search in order to move to a specific one. Access has no way of knowing which one you want unless you can choose some other identifying information. Larry Linson Microsoft Access MVP "timsken" wrote in message ... I know how to find a specific record using a combo box along with GoToControl then FindRecord. I have set up a form and want to find a record by first and last name (which are in different fields). I can find by last name or first name but not both. As it is, when finding by last name, for example, it takes me to the first of that name i.e. the first "Alexander" and then I have to scroll through the records to the specific "Alexander" I want. Can anyone tell me how to set it up so I can go to the specific "Alexander" that I want. Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change background colour of a specific field in current record | renold1958 | General Discussion | 1 | August 25th, 2005 04:00 AM |
I can't find records using the the find record command in a merged | Johnny Tidwell | Mailmerge | 1 | June 23rd, 2005 11:37 AM |
Find Record Combos | Dave | General Discussion | 1 | May 12th, 2005 06:18 PM |
Find Record in Subform | Shalyn | General Discussion | 3 | May 12th, 2005 06:45 AM |
Form Doesn't Go To New Record | Steve | New Users | 15 | May 16th, 2004 04:33 PM |