How do I use .Requery

[wjoc1]

Hi I have a form and when the value in a certain control is changed I want a query to refresh its data so that when I open another combo box on the form it will list the right values(picked up from the query).

How do I get the query to refresh itself?
I've been messing around with QueryDefs and Recordsets and all this stuff but I can't get it to work. It is driving me CRAZY.

Please help me.....

Liam

 

[Dave Eyley]

Try -



DoCmd.Requery("ObjectName")



on the AFTERUPDATE property on the preceeding action.

HTH

Dave E