How to make a query run when textbox updates?

[Sarengo]

Hello!

I deleted and redid the forms/query and it now works. Something else came up though. For my query under critera I have:

[Forms]![frmArea].[txtArea]

This should make the query run whenever txtArea is updated (as far as I know...) but it pops up that "Enter Parameter Value" each time with that above line as the text. Am I missing something?

Thanks for your patience and time!

~Sar

[Stewart Ross]

Hi Sarengo. You are mistaken about what your reference to Forms!frmArea!txtArea actually does. When placed in the criteria of a field in the query editor it becomes part of the Where clause of your query - as you will see if you view the SQL for your query instead of viewing it in design mode.

The parameter dialogue arises if the form is not open at the time you run the query, as Access has no value it can assign to the form control reference in your Where clause.

If you want to run something after updating a control on a form you will have to do it by writing suitable VBA code triggered from the AfterUpdate event of the control concerned. It cannot be done by placing a reference to a control into a query.

-Stewart