Update a table from an unrelated form

[Veli Izzet]

Hi all,

I want to update a record in a table from a command button on a form not
related to that form.

The cmdUpdate will take some values from the form frmForm itself, open
tblTable and add one record.

Thanks for any help..

 

[Guest]

I am not sure what you are trying to update but it seems like an Append or
Update query might be what you need. Add the tables and criteria you need to
update/append tables unrelated to your current form.

Hope this helps.

 

[Guest]

The cmdUpdate will take some values from the form frmForm itself, open

tblTable and add one record.

What you stated here is not 'updating' but is 'appending' a record.
Updating revises data in a current record.

See Append Query in the Help.