When I enter the surname of a person in the text box on a form i want to be able to automatically check against a list of names in a table that details staff not to employ and alert the user to this fact but not stop them from carrying on.
I am a bit of a novice in terms of expressions and vb so go easy, I think maybe I whould use a dlookup but do not know where to start.
Many thanks in anticipation,
Rob
I am a bit of a novice in terms of expressions and vb so go easy, I think maybe I whould use a dlookup but do not know where to start.
Many thanks in anticipation,
Rob