Forms question

R

rob

I have to create an Access program. Basically I need to create one table and
form in which information namely school marks (total mark) will be entered.
Second this information is then relayed to a second person who tallies up the
subtests and enters another number in another total column probably on
another form. At the end of the day this number should be the same as the
number entered by the first person. If it's not we need to display an error
message or warning. Please help.
How can I accomplish this (2 forms, one main one sub linked on a query which
will update it as it is entered and code to link the results of one to
another else an error message. I guess i will have two fields on each form
idnumber mark and id number mark2. Hope someone can help. Thanks.
 
Top