JUST LEARNING - need to prompt for ID and display other information on form

[jm001]

Hi,

I am creating a database that will hold contact information plus
additional information on different tables. ID on contact will auto
assign. I want to have the system prompt for ID and then display the
contact name on forms when a user opens a form. If there is no match
on ID then it should display a message to create contact. If match,
the form should open to that ID record and display the name from the
contact table. Hope this is simple, need to do this quickly

[Robert Davis]

I would recomend that you open the form in design view.

Make sure the Wizard tool is on.
Then drag a combo box to the form. A wizard will then walk you through
finding a record to populate the form based on the value selected.

Then I would drag a command button to the form that would allow for a
new record to be added. When you drag the button on to the form a
wizard will walk you through that operation as well.

Hope that helps.