Creating Forms in Access

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

Guest

Hello,

How do I create a form in Access where I can just type a person's Last Name
for example and then all of the information relating to that person will
automatically appear in the form?

Thank you.
 
Jane,
Create a 2 column combo box with your unique Customer key field (ex.
CustomerID) in the first column (hidden), and Customer names in the second
column. Ex.ColumnWidths = 0"; 1.75"
While it appears as though you're selecting and displaying the Customer
Name, you're really storing the key value in the combo field.
Now... a subform based on your customer address, city, state, etc...
linked to the combo box via the key field, can display all the associated
customer info.
hth
Al Camp
 
Hello,

How do I create a form in Access where I can just type a person's Last Name
for example and then all of the information relating to that person will
automatically appear in the form?

Thank you.
Click to expand...

Create a new form (or use an existing one) that contains all of the
fields you wish to see.

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

However, using a Last Name by itself to find a record is risky at
best, as it's quite common for more than one person to have the same
last name. How would you differentiate between Joe Smith and John
Smith?

In the Combo Box, use a Prime Key field, LastName field, FirstName
field and perhaps an Address field in the combo box. You would hide
the Prime Key field, and display the others. You can then select the
correct individual, and Access can locate the correct record by using
the Prime Key field.
 
Back
Top