retrieving information from query and displaying in a form

[ajaymansata]

hi.I have a problem and do not know how to go about.
Actually i have 3 tables.
Personal table,employment information and edu table.
i have a search form which has 3 fields
last name id SSn
what i want to do is that when user enters the 3 fields i want to fire a query which retrieves data from all the three table for that match criteria and display it in a form.This all happens as soon as user clicks a button on the search form.
Could you please suggest me how can i do this and show the results from all the three tables in ONE Form.
ajay

 

[Jack Cowley]

Create your query and then create a form based on the query. In your Search form put in your criteria fields and a command button. In the query refer to the fields on your form in the Critera field. Just have the command button open your form after the criteia fields are filled in. The form will open with the selected data.