refreshing the query results on a page

[jlabre01]

Hi,

I'm trying to make a query based form, so i start at one form that just has a combo box with all the company names, then i push a command button to open the next form, which contains the results of the query. at the bottom of the page i put a button to go back to the previous page in order to do a new search. but when i select a new company name and press the command button again the results from the previous search are displayed. so the question is, what do i have to do in the event in order to get the proper search results each time?

thanks in advance,

jlabre01

 

[SUN]

Try to add a code to after update event

Me.Requery

 

[twoplustwo]

Or at the end of the OnClick event