Requery

[b0gdan]

Hi,
I have a search form and a form that display the result of the search based on the search criteria from the search form. The query works just fine and the search results are displayed well but the problem is the following: the query doesn't work with the new records inserted in those tables, only records that were in the table at the moment i had developed that search button are displayed. If someone can tell me if there exist a sort of "requery" method for that query to display the new records.

Thanks,
b0gdan

 

[grnzbra]

This isn't an exact match to your problem, but is similar when using ComboBox. I might give you some useful ideas.
http://www.access-programmers.co.uk/forums/showthread.php?t=112891&highlight=list

 

[boblarson]

This part makes me go huh???

only records that were in the table at the moment i had developed that search button are displayed

Let's say you created the search button 3 days ago. Does that mean that your search doesn't return any records from 3 days ago to today? If that is truly the case then there's something wrong with your query that is limiting the records for some reason. So, I would post your query here if that is the case so we can take a look. To post the query, just in case you didn't know, go into the query in design view and then select VIEW / SQL VIEW, and then copy and paste the SQL statement here.