I have a form with a field named ID. I need to store the value of that ID in a table called tblID in the field SID. tblID only has one record as it is temporary storage and gets replaced often.
Any help in writing the vba would be most appreciated.