Forms running queries

[Robert]

My users use a form named "Hous Auth Request". The user
clicks on cmd button and many procedures are ran. One
thing it does is update a table with information that is
on the form. The update is done using an update query.

My problem is one of fields in the update query is based on
text box on the form (i.e. [Forms]![Hous Auth Request]!
[cmbESDStaff] is the criteria for the query)

I guess the forms closes while the procedures are
running. So I keep getting the message "Enter Parameter
Value" for [Forms]![Hous Auth Request]![cmbESDStaff]
because the query is running.

I have tried macro, call statements, docmd but nothing is
working.

Is just hopeless. If I could somehow keep the form open
then the query would be able to get information from the
text box.

Any help

 

[John Vinson]

My users use a form named "Hous Auth Request". The user
clicks on cmd button and many procedures are ran. One
thing it does is update a table with information that is
on the form. The update is done using an update query.

Please post the code behind the command button and the SQL of the
query. You probably do need to close the form (an update query and an
open form both editing the same record WILL conflict); but you can
probably capture the parameter and pass it to the query.