I have two tables... GRADES (StudentID, Assignment#, Score) and ASSIGNMENTS (Assign#, Assign Desc, Max Possible Score). On a form, how do I make sure a score that is not greater then the 'Max Possible Score' is not entered?

Also on a form, can you use radio buttons instead of a combo box? The possible choices are coming from another table (tblCodes).

Have some knowledge in VB, if needed.

Use the before update event of your score control, to validate the max score permitted by using DLookup. The answer to the second question is probably yes, but why would you want to?

Thanks Rich, but can you explain DLookup, or where I can find info on it? I was using a SQL statement in the update event, but the only thing I know about SQL is how to write the statements... how do you execute them in an event procedure...maybe you can just recommend a good book(s) on SQL, VB, VBA with Access?

I was just curious about the radio buttons...think they look cleaner in some instances.