Hi, I am working on a query to update only 1 field to start, but multiple later on a single record. The only record to be changed is the current record opened in the form. I am struggling with this and would love some help.
Hi, I am working on a query to update only 1 field to start, but multiple later on a single record. The only record to be changed is the current record opened in the form. I am struggling with this and would love some help.
your update query will look at the key on the form, then just run the query, docmd.runquery "quUpdate'
update table set [field] = 'new value' where [id]= forms!myForm!txtID
ok, so I put the where [ID]= forms!temp!txtID into my criteria, it is still updating 0 records... and the where [ID]= forms!temp!txtID is getting split into 2 seperate lines next to the original set. right now it looks like this....
field1 next box "where [ID]"
temp next box
field2 next box
empty crieteria next box [forms]![temp]![txtID]
what am I doing wrong?
figured it out thanks guys, I was edditing in access when I shoulda looked at the sql stuff
You DO edit in the access query.