Queries and Afterupdate on Forms

[moscgama]

Hi,

I have a form based off a query that pulls information when inputting an ID. For example, user clicks the form, then a pop-up box (from the query) occurs, then after adding ID, the form with populated data appears. However, I would like to change some control properties on the form depending on results of the specified ID when opening the form. At this point, I have an Afterupdate event attached to the ID field on the form, which I thought would work (Note: the data on which the control properties will be based are in another table). After doing some research, I found out that the results from the query won't trigger an Afterupdate event. Unfortunately, I don't know VBA well enough or SQL to figure out possible options. Does anyone have ideas on how to circumvent this issue? (I only need steps at this point, but that will likely change )

Thanks in advance for the help and please let me know if I need to clarify anything! (Also, I apologize if I'm posting this in the wrong place.)

 

[JHB]

I think you can use the form's on current event instead.

 

[moscgama]

Hi JHB,

Thanks for the reply! I tried the "Oncurrent event" and it worked! I tend to make things more complicated than they need to be. A lot of what I do ends up like a Rube Goldberg machine!

Thanks again!

 

[JHB]

You're welcome, luck with your project.