From a form check if a name exists on a different table

[S. Matthew]

When I select a name from a combo box in a form I would
like it to search another table to check if the selected
name exists. If the name exists in the table a flag
image should appear on the form.

Please help me write the code for this operation.

Thanks
S. Matthew

 

[TK]

Probably the easiest way is to use the DLookup function
If DLookup("nameField","table to check","nameField = '" & me.your combo box
control name & "'") Then
turn on your flag
End if

The above assumes your name field is a text field - so you use the single
quote inside the double quotes.
HTH

TK

 

[Allen Browne]

Use DLookup() to see if the entry exists.
For an explanation of how to use it, see:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html

You could set the ControlSource of your text box to:
=IsNull(DLookup(...))
and set the Format property to the flag character (using the Wingdings
font).