Update Table from an unbound form

G

Guest

Is it possible to update a table from an unbound form? I can do this and
append data to a table but in this case, I already have data in the table and
want to update 2 or 3 fields in a specific record in a specific table.
Thanks for the help....
 
G

Guest

Sure, it is exactly the same, except you don't use the .AddNew. You just
have to position your table so the record you want to update is the current
record.
rstMyRecSet![SOME_STUFF] = Me.txtSomeStuff
rstMyRecSet![OTHER_STUFF] = Me.txtOtherStuff
rstMyRecSet.Update
 
M

Margaret Bartley

Another way is to use RunSQL:

strFormFieldName=Me.FormFieldName
DoCmd.RunSQL "UPDATE [MyTable] SET [FieldName] = '" & strFormFieldName &
"'"

or
iFormFieldName=Me.FormFieldName
DoCmd.RunSQL "UPDATE [MyTable] SET [FieldName] = " & iFormFieldName & "
 

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

TimeStamp Record 7
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
unbound form returns values to table 2
UPDATE TABLE FROM UNBOUND QUERY 3
VBA - retrieve data on last create named range from previous inserted named range 0
Update certain record fields in one table if data exists in anothe 1
How to get a control's default value to update when changing recor 2
bound form with unbound fields needing updating to the same record 1

Top