I am new to Access Query and this forum.
Need to find out
1) how to create query to get data from few tables (linked by keys) and
2) how to populate the result in a form.
Would appreciate if someone can help by pointing a link or give a brief idea on how it should be done, by VBA or SQL or by Query Wizard. I tried with Query Wizard without success. Thank you in advance.

Just make a Select query with the fields you want.
Then make a form with the form wizard using that query as the record source.

Waht kind of problems are you having with the query?

Thank you for the reply.

1) I have created a form for user to input the search field and could not put into the wizard
2) I thought of using SQL or VBA (recordset???) but have not been successful.
3) Do not know how to output the final result from the query to a form i designed

Briefly,i did and wanted to do
1) Created 3 tables
2) Created input form to get user to input search value
3) want to retrieve selected fields from each of the tables (meeting the criteria) and populate into a form created to display the results

Is VBA and SQL the better and more effficient way to [erform such task?

Have you made a query based on the tables and including the fields you want?

If your query works than you should be able to enter its name in the Record Source property in the design view of the form. If you follow the wizard and enter the query name when asked it should be there.

Any textbox etc on the form is connected to a field in the query by putting the field name in the Control Source property of the tecxtbox. This makes them "bound" to the field. Have you achieved this on your form?

Then you run a find record procedure based on something you type into an unbound box.

Oh...ok...will try again.