Run Update Query for current record

  • Thread starter mattc66 via AccessMonster.com
  • Start date
M

mattc66 via AccessMonster.com

I have button on my form that runs an Update Query. However I want to limit
the query to only run based on the current record on the form. How would l
best handle this issue?
 
V

Van T. Dinh

If you have some Field on the Form that can uniquely identify the Record,
you can use this as the criteria in your Update ... something like

CurrentDb.Execute "UPDATE ..... SET .... " & _
"WHERE [IDField] = " & Me.IDField, dbFailOn Error

(assuming a numeric IDField).

Is your Form updatable? If so, you may create conflicts since you update
the same record via the Form and the Update SQL.
 

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

Similar Threads

Need combo box to refresh when moving to new record 2017 1
Add current record to table 3
Update Query based on Current Recordset 26
how to run update query on current record only 8
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Update Query for Current Record 3
Inserting a beginning record in a subform 2
Setting field value if a value exists in another table 3

Top