How to: automatically generate details in a form

  • Thread starter Thread starter shoa
  • Start date Start date
S

shoa

Hello all

I have a table in an Access database with some records in it. Now I have to
create a Form for that table (the form show the details of a record or to
entry more records). What I want is that each time, when I enter a value for
the field of the primary key in this form and press Enter key, if a record
has similar entering value, the detail of that record will be shown.

For example, in my table of customer that have 3 customers with customer IDs
(primary key) are 13, 24, 23. When I enter 24, the details of that customer
(address and phone number...) will be shown in the form. I tried but nothing
work. (I am not allowed to use a button "Search record" in the form). Could
you please help!!!!
Many thanks
S.Hoa
 
Put a combobox on your form.
The wizard will ask what you want it to do -
choose the 3rd option - go to a record based on the value in the
combobox.
The wizard should walk you through the rest of the procedure.

HTH
- Turtle
 
Back
Top