query results based on loaded form

[action]

I am trying display the results of a query in a list box based from the record viewed in a form. I can get the correct listbox results for the 1st record displayed by running the query as the form loads but other records don't update. I need to run the query each time a new record is displayed, can this be done without code or does anybody have some code that will do it?

Cheers

 

[pono1]

Action,

How are you "running the query as the form loads"? In code? If so, cut the section of code that does this in the load event and paste it into the form's current event. If not, and if your listbox has a query for its rowsource, put somethng like this in the form's current event.

	Me.TheListBoxName.Requery

Regards,
Tim

 

[action]

That worked, thanks Tim

 

[action]

thanks

thanks Pat, you guys are an endless source of learning.