Yes a total Newbie to Access Forms and I have searched the forum and found many ways to validate data entered in a form, but which is the easiest / Best to use here in this scenario...
Here is the requirement
I have a 4 Field FORM that data is entered in to populate, let's say "Table Z" ...
Field 1 -REQUIRED Field - When user enters data - it must be on Dictionary Table X
Field 2 -REQUIRED Field - When user enters data - it must be on Dictionary Table Y
Field 3 -REQUIRED Field
Field 4 -REQUIRED Field
Do I use BeforeUpdate, AfterUpdate, DoLookup, a Query ???..
Please help !!
Hopefully someone out here will help and point me in th right direction to get me solution