Find Specific Record using 2 controls

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
_______________________________________

:

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
 
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
 
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
____________________________________

:

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
 
Back
Top