Run Update

[bunji]

I have a form that has a combo box, once a user selects the required entry it the form performs several tasks after update.

If the required entry isnt listed the user clicks on the add button which opens a form to fill in the necessary details for that entry. Once complete the user clicks on the save button and the form closes updating the combo box on the previous form. But the after update tasks do not happen.

I have tried things like....

[Forms]![Frm1].reload
[Forms]![Frm1].refresh

etc

But cant seem to get it to work. Any ideas?? Thanks

 

[ThreeCrow]

Try

Me.cboSearch.Requery


cboSearch = the name of you ComboBox


Hope this helps

 

[bunji]

No unfortunately that didnt work. I just need to some get it to run teh after update code. but because it doesnt detect the mouse cusor entering or leaving the field it doesnt know its been updated.

I guess i could write a public function that it runs after giving the field its value.