I need to check one field on form open and update it if it has changed. I have a query that returns all the columns needed and can be filtered by EmployeeID. What I want to do is add to the form open event a check if the employee position has changed and update a text box with a numeric value if it has. My thought was to run the query filtered by employeeid which will return one record. From that record I would like to save POSID to a tempvars, then compare the tempvars value to the Position field and update Position if it doesn't match. I'm not sure if a recordset would be the better way to go but the employee position table holds several positions and it's only the most recent one (by date) that I want to work with. I hope this isn't too vague. I can upload the table if needed but it's rather large and I would need to strip out employee info.