View Full Version : Using Query in Form


jroeiv3678
09-13-2000, 08:23 AM
Sorry this maybe a very simple question, but please bear with me. I am trying to input information into a form, and take that information to show matching data from a query.

Example
Input John on Form
In the query John 23 Ohio
Then after input show on form Ohio

Jack Cowley
09-13-2000, 08:36 AM
I am not quite clear on your question but if you want to show a specific record on a From by making a selection from a Combo box or entering data into a text field I would suggest the following:

Use the Form Wizard to create a form based on your query. When you have the form the way you want create a Combo box using the Wizard and from the first screen select the third radio button, "Find a record...". Finish the Wizard. Now when you select John from the Combo box the related data will be displayed on the form.

HTH,
Jack

[This message has been edited by Jack Cowley (edited 09-13-2000).]