AfterUpdate trigger

[GaelicFatboy]

I’ve got a popup, modal ‘Search’ form that is used to search for a building project id#. Once this number is found a command button can be pressed to write this id# into a textbox of a second ‘Project’ form residing in the background and then close the ‘Search’ form, bringing the ‘Project’ form into focus.

The problem I have is being able to call the ‘AfterUpdate’ sub procedure of the id# textbox within the ‘Project’ form. What code can I write to trigger this procedure from the ‘Search’ form?

Cheers

D

 

[SOS]

Change the After Update event that you want to call from Private Sub to Public Sub and then you call it like:

Call Form_Project.YourTextBoxName_AfterUpdate

And if you have special characters in object names (like #) get rid of them as they will cause you no end of grief if you don't - # is a key delimiter (for dates) in Access and using that for object names is a bad thing. (just an FYI for you)

 

[GaelicFatboy]

Cheers for that,

I always seem to be tripped up by the exact syntax needed (the help screen were pretty pants), I was so close to getting it to work earlier, but it's very difficult to know if you're heading in the right direction. Still the forum came to the rescue once again.

Thanks for your help, much appreciated.

D