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