I am new to VB and would like to know what is the best method for Validating fields. Am I better off Validating at Save time eg. When the user has finished creating a Team Member record and goes to save it, does the Team exist in the Team Table for that record, does the club exist in the Club table for that record etc. Or would it be easier for the user to get told at entry time that their input is not correct? If anybody has any ideas I would appreciate an example.

Thanx in advance, Thomas