Getting A Form To Pull Out Data.

[swain90]

I am currently setting up a database for a shop. Everytime the shop keeper makes a slae he has to open a seperate form. Now every time he opens this form he wants it so that he is prompted to ask for a product ID. Once the ID is entered he wants it to bring up the information this product. I am unsure on how to do this any help please.

Regards
Swain90

[OBP]

There are 2 answers to your question, both use Combo Boxes, depending on what the form is for, if it for data entry and the User wants make entries Including the data then it is best to use a Standard Combo Box to select the Items to go IN TO the form.
If they want to Select a Record on the Form for modification then use a Combo box for "Finding a Record on the Form".