Automatically show data

[summer]

I have a database that lists test requirements for certain materials. Here's what I want to do. I want to set up a form where I can type in the material number, hit enter (or a command button [macro?])and have the form automatically display the test requirements. Can anyone help me?

 

[Jack Cowley]

Create your form to display your test results. On the form create a Combo box using the Wizard and on the first screen select the 3rd choice, "Find a record...". Finish the Wizard and now selecting a test from the Combo box will display the information you want.

 

[summer]

Thanks Jack. If I want the person using this to be able to open this and type in the description number to search results, what mode would I have it open in?

 

[Jack Cowley]

Just open the form. The default settings should open the form to show the first record. The user can then select the Material number and hit the enter key and the form should then display the data that they want....

 

[summer]

Thanks for your help!

 

[summer]

One more thing I just thought of...
How can I prevent accidental changes in data from occurring? The people who will be using this form are not big computer users.