Querying a database that you just put new data into

[illy2k]

I have a form with a subform on it. The person entering is entering multiple things on the main form, and on the subform I have the the recordset being set to the results of a query which is run after the main form contents have been added to the database. However on the first run of the query there is nothing put onto the subform. Only after the second item is entered do the results of the query show up on the subform, with both items being there. How do I write something to update the database immediately to reflect the changes I just made, so the query finds the new results the first time??

 

[illy2k]

A little more info

I am creating running a query on the click of a button to set the RecordSource of a subform to a query that is dynamic. However, when I run the query after entering something new on the main form, the query does not show the new data right after it is entered. It only shows the data when you enter a second item. After this it works fine. Is there anything I can do to update the table immediately to reflect changes so that the query works the first time?