Change Status fields

[srele24]

Update fields in Table


I have two tables X and Face. when I enter the Date in the Face table in Table X I need to change the field to StatusID = 2. The previous status of the StatusId field can be any value between 1 and 6. Please help

[ranman256]

run a query : docmd.openquery "quUpdTblXstatus
the query would use the status combo on the form , look like:

update tableX set tblX.Status= forms!myForm!cboStatus where tblX.key = forms!myForm!txtKey