another requery question

[AN60]

I have put Me.requery in the onactivate event on a sub form. During testing it worked ok when I needed to update two combos to show the latest changes. This worked once and then didn't work after that. Am I on the right track or headed in the wrong direction?

 

[maxmangion]

try using the OnCurrent event of your form and then in the AfterUpdate of your Combo call the OnCurrent sub.

 

[Rich]

Don't put Me.Requery in the CurrentEvent, it'll loop endlessly

 

[mohammadagul]

ok when are you trying to requery you subform. If it is on entering the subform from the main form the you can use the onenter event of the subform. put the same code in the onenter event of you subform and try again it would work.