I have an update query I’d like to run from a form.
The query’s criteria cell is already setup. What I need is a way to fill in the “Update To:” cell and run the query from the form.
A toggle button on the form would run the query.
Let’s say the query’s name is qryUpdate. The field the query will update is tblStanding.TripDate. The form is frmSelection and the input control that will hold the value to be sent to the query is named frmSelector.ctrDaily.
Oh, and if it’s not already obvious, the value to be sent will be a date, like 4/1/2010.
Well, you would still get the warnings but you can code around it. Look at OpenQuery and SetWarnings in VBA help. Normally I would recommend the Execute method but I don't think it can handle the form reference.