I dunno if that's an accurate way of describing the problem, but here goes:

I have a database that I want to implement an If statement into.

Essentially, the user inputs a string, and depending on whether the string exists in a table or not, the correct form opens.

I don't know how to write the expression that would return a true/false value when it looks for the string in the specific table.
Any ideas?

P.S. I have a query that will give me a true/false value for the record, but I can't get VB to pick it up as a variable.

------------------
Legalese:
Anything I say on this forum is strictly my own opinion, and if I make a jerk out of myself, it has NOTHING to do with the company.