Need help to do a look up in Access

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

Guest

I have a table with Chit# , last name and first name. I want to make a form
where I can type in a number say....3 and hit a button and get the name, last
and first who corresponds the the chit #3. Any and all help would be greatly
appreciated.
 
Just me said:
I have a table with Chit# , last name and first name. I want to make
a form where I can type in a number say....3 and hit a button and get
the name, last and first who corresponds the the chit #3. Any and all
help would be greatly appreciated.
Click to expand...

The simplest thing to do here is to base the form on your table, then
add an unbound combo box to the form using the combo box wizard. Tell
the wizard that you want to "find a record on my form", and let the
wizard guide you through the process of building the combo box. You
won't actually need a separate button.
 
Dirk
Not exactly what I was looking for but the out-come is the same. I
appreciate the help. It worked out pretty good.
Thanks again for your time and help
 
Back
Top