Hey guys,

I'm looking to update two fields based on another field through a form. Basically a user will enter a number into Site_Key on a form. I would like two other fields to be updated to this number as soon as they do it or click on another field. Can someone help me with a macro for this? Thanks.

Use an update query.

UPDATE YourTableName SET FirstFieldToUpdate=SomeValue, SecondFieldToUpdate=SomeValue WHERE KeyField=Site_Key;