-
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.
-
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
-
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.
