Make a query run when a form is opened

[rgates]

Please help. I am not new to Access, but I haven't done much with some parts of it.

I have a table and ran a query on that table. I have a form that displays data from the query. How can I make the query run when the form is opened so the data is current. Data entry happens at the table level via another form.

 

[namliam]

Every time you open the form the table is requeried automaticaly....

If you want to add a button to the form to " refresh" the data, you can do
Me.Requery
In that button, I hope this is what you are looking for, your question is not overly clear.

 

[rgates]

I'll try to be more precise

I have a form (FormA) that is used to enter data in a table (table1).
I wrote two make-table queries (query x and query y) that divide that data and places it in two other tables. (table2 and table3)
I created a form (FormB) that just reads and displays the data from table2.
When I change data on table 1 Form B will not update until I have re-run query x.

How do I make query x run when form B is opened?

Thank you very much for addressing my issue.

 

[namliam]

YOU DONT

You dont do stuff like this!

Why make a make table query? To create a new table if you need the original table??

Just use a query as the source for you form and have it fetch data direct from the table. Using make table queries like this NO WAY !

 

[rgates]

I'll see if I can figure out how to do that. That's what you get for teaching yourself! Thank you.

 

[namliam]

Just change your make table query to a "normal" query (presume you know how to do that)

Now use your "old make table query" as input for your form either when creating the form using the wizard or by changing the "rowsource property" of the form.

 

[rgates]

Thank you very much. I created a select query and made that the source of my form. It works every time now. I appreciate the help very much. I am greatful that you took the time to answer my little inquiry. I learned much more than you know.

R. Gates