Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

how to show/hide a whole table in query based on user input

Status
Not open for further replies.

train2

Technical User
Mar 18, 2003
47
0
0
GB
I can't find a similar thread to answer this question.

I have users selecting on a form, to include fields in a query. The data is from the same table that I've included three times in the query design, and I'd want them to make up to 3 choices.

I've got it working fine for when they make 3 choices. But I need a way to either hide the repeated table in the query, or to hide the fields for that table should they make fewer choices.

Any ideas?
train2

 
This is the way I'm just trying....

I'm basically writing in VB to create the SQL syntax based on whether fields are blank / or not.

Is this logical?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top