Multi Choices

D

Dan @BCBS

I'm so far behind on delevering this database I can't think straight..

I have to allow the user to choose from 3 list boxes and return the report
based on those choices.

This code has two of the choices on it..

How do I make it now report on the two choices?
Then I have ot add the next.

Thanks
 
J

Jeff Boyce

Dan

I'm having trouble visualizing your setup...

Are you saying you want to select/enter items on a form, then run a report
based on those selections? If so, one approach would be to write a dynamic
SQL statement in code behind a button-click on that form. By dynamic, I
mean that the code would examine the values selected and build up a SQL
statement that you'd use in a:
DoCmd.OpenReport,...
statement to provide the "WHERE" clause.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
D

Dan @BCBS

Thanks for the answer I had sent my message before adding my code.
I resent and have recevied some ideas.

Thanks
 
Top