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.
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.