code to check field in a table

G

Guest

i have a form whereby a user inputs data in a textbox to a
field in table1.
the data will be telly with a field for all records in
table2. if the input data is not found in table2. data
will not be updated in table1.

how do i code this? and where should i put this code
(before update event of textbox)?
 
Top