Proper steps to display query in a form

  • Thread starter Thread starter SMERTZ
  • Start date Start date
S

SMERTZ

Using Access 2003, what are the proper steps to run a query and display the
results in a form? The query will have a one-to-many relationship. That is
the query will query customers table and an orders table linked by Customer
ID.

I assume the steps are
1. Design a form
2. Design a query

How do I get the query results to display in the form?


Thanks
 
Using Access 2003, what are the proper steps to run a query and display the
results in a form? The query will have a one-to-many relationship. That is
the query will query customers table and an orders table linked by Customer
ID.

I assume the steps are
1. Design a form
2. Design a query

How do I get the query results to display in the form?

Thanks
Click to expand...

i would suggest doing the query first.

Then create a form, using the query as it's record source.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query Parameter using multiple options 0
Launching a Form from Within a Form to Create a New Record 1
Access Access Report Works on One Machine but not Another 3
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Form question: Simplest way to bring in a query result that is notthe record source into a form? 3
Displaying query result on the same form as selection fields 6
Insert query in a form 2
Create a Form (with Subforms) Based on A Query/Queries 1

Back
Top