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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Dynamic sql statement using values from combo boxes
May have solved my own prob. sorta a hack or spagetti code if you will. I made a bunch of if statements that took care of all possibilities. in each if I have a rowsource="<the correct sql statement>" seems to work, just kindof a cheesy way of doing it. If anyone knows of the...- jamato
- Post #5
- Forum: Microsoft: Access Forms
-
Dynamic sql statement using values from combo boxes
Actually, the user can choose all, some or none of the parameters. That is where my problems lies, I cannot figure out how to make the where statement in my query change to handle a scenerio where a user does not use all of the parameters. My where statement needs to be able to dynamically...- jamato
- Post #4
- Forum: Microsoft: Access Forms
-
Dynamic sql statement using values from combo boxes
I am creating a form that will search a table based on up to three parameters and display the results in a list in which the user can select from. The table has 4 fields. fields 1-3 are the parameters and the 4th is a corresponding document name based on the first three fields. example: fld1...- jamato
- Thread
- Replies: 7
- Forum: Microsoft: Access Forms
