I have a Revenue tbl which a user fills in on a form. Recently, I have added 2 other fields to this table called Approved and Finalized. I want to put a code behind my command button so everytime they click Approve, it would put 1 in the field and if they press Finalized put 2 in the field. I don't know how to code that. Could anybody help me with this? Thanks in advance http://www.access-programmers.co.uk/ubb/smile.gif

Why wouldn t you use a boolean field instead. It can take the values True/yes (= -1), False/No (=0), and eventually Null.
And doesn t require any code.

Alex

[This message has been edited by Alexandre (edited 02-05-2002).]