bring the whole record on the form based on one field

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

Guest

hi

i have created a form on a table, and i want just with typing into one of
the fields ( primary key field) bring up all the rest of the record into
other fields.

is there a way to do this?

thanks
 
hi

i have created a form on a table, and i want just with typing into one of
the fields ( primary key field) bring up all the rest of the record into
other fields.

is there a way to do this?

thanks
Click to expand...

Sure.
Add an unbound combo box to the Form Header. Use the Combo Wizard and
select the 3rd option on the first page of questions, something like
"Find a record ...".

It's very unusual to search for a record though by typing in it's
prime key (who would remember that 12896 is the prime key for the
"John Benson Company"?

In the Combo Box, include the Prime Key field plus some additional
field that would permit you to find the correct record, i.e. Company
Name. You would hide the Prime Key field, and display the Company
Name. The wizard will do this for you. You can then select the correct
individual, and Access can locate the correct record by using the
hidden Prime Key field.
 
Back
Top