Validating data entry

[Mocko]

I am sure this is simple but I can't think how to solve it.

I have an unbound form [frmInitials] with one text box [InitialBox] and one button. I would like the form to check the initials entered against a table [Users] holding a list of valid users initials(field [UserInitials]) and if the initials are valid to continue and if not to flash a warning and close.

How do I do it?

Thanks

 

[PHV]

Why not playing with a ComboBox ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Mocko]

After an hour or so of playing, a combination of a combobox and the onnotinlist event seems to do it!

Thanks!