Capturing Fields as Variables

[JohnAtWork]

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.

[DVint]

You'd be surprized how many people have trouble putting a variable into a Seek or FindFirst. Why don't you post the query that doesn't work and I'll help you make it work, if someone else doesn't beat me to it.
Dave

[JohnAtWork]

Actually, I worked around the problem entirely by incorporating two queries into one, and changing the concept a bit.

I switched from two forms and an If statement opening them to one form with properties that are dynamic according to the true/false value I was trying to capture earlier.

But I will post an example query for the problem I stated earlier because I am interested; I will get it up later today.