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

You could do that but....

You have to have something to lookup for example a field specifying whether to hire or not.

But if the field already exists and it is attached to a specific person anyway there is no need to look it up.

Simply make sure that field is included in your record set that the form is made from and then include the field on the form. Use what you already have.

If you need more detail send me a copy in 97 with as little data as possible and I will see what I can do for you.