S
Song
I have 2 tables:
tblException tblStudent
SSN SSN
Last
First
M
tblStudent has many records and some records are duplicate
I want to set up a continous form to enter data into tblException. When the
focus moves away from SSN field (BeforeUpdate event, I guess), I want Last,
First M of tblStudent to show next to it. If SSN entered cannot be found in
tblStudent, a warning message should popup and update is canceled. How to
code that? Thanks.
tblException tblStudent
SSN SSN
Last
First
M
tblStudent has many records and some records are duplicate
I want to set up a continous form to enter data into tblException. When the
focus moves away from SSN field (BeforeUpdate event, I guess), I want Last,
First M of tblStudent to show next to it. If SSN entered cannot be found in
tblStudent, a warning message should popup and update is canceled. How to
code that? Thanks.