Field on Form

[BenjaminTheBlue]

Apologies first, because this is probably something so easy. I have searched the forum 1st, but cant seem to find anything.

Problem: -

Ive created a Database, containing a few forms linked to a few tables. What I need is a field at the top of each form, that someone can fill in the words "approved" or "not approved" and the database remember and display this whenever the database is re-opened. It doesnt have to be a combo box.

I stumbled on a few things similar, but thought I would ask is there a very simple way as they seemed quite complicated for me being an access beginner

Thanks in advance for any help Ben

 

[David Eagar]

A few things -
First: the form should be based on a query, not directly off the table
Second: for the db to 'remember' it, it must be stored somewhere (ie a field in a table)
Third: A simple Y/N box in an Approved field would solve your problem and give your users less typing (and chances for mis-spelling)