Validate data in a field with data in another table

[Lreader]

I have to create an event procedure.I have a form with a control based on a field [account] from TableA
When an account number is entered in that field, I want Acces to check in a specific field in TableB if that number exist: if it doesn't I need a message box to indicate the warning!

I just begin with VBA code and I am unable to do that!

Thanks for help if it is possible!

 

[mfulton]

If it were me, I would use a combo box or list box based on the table that lists the accounts. This would allow the user to select from existing accounts only. Michelle Fulton

 

[Albano]

Hello,
You can use the Dlookup() function to find on the TableB the number and the send de message box.

Their's the code

Dim Found as variant

Found=DLookup("[Filed from tableB]", "TableB", "[Criteria Field] =" & TextBox value)

if Found then
MsGbox("Record Existe&quot
End if

Is someting like this, tray found more info about the Dlookup Function on Acess Help.

Good luck.
Albano