Run Update Query From Form

May 18, 2010
Reaction score
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.

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.

Is there VBA code that will accomplish this.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question