I have 11 listboxes on my main form and they are multi-select for user input. After the user inputs what they would like to see on the subform display, they would click the command button and it would take whatever they selected and then look at the recordsource query to use that query to filter by what they selected from the 11 listboxes. My problem is I cannot get it to work. When clicking the command button it does nothing. Here is my code:
Please Login or Register to view this content.
Hi, tmill29,
where does the local variable strWhere gets filled?
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Isn't that here?
Please Login or Register to view this content.
Oh no it is here:
Please Login or Register to view this content.
Yes, but you have not set any value for the variable strWhere. You have defined it with your Dim statement, but it has no value.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Hi, tmill29,
usually you build a connection to the database, create a recordset from the criteria you choose and copy back to the target - if you work from Excel you would need to add these things in order to work. Simply assigning a SQL-String (to what?) won´t create any result from Excel.
BTW: maybe attach a sample file of the workbook.
Ciao,
Holger
I just noticed that you have no command to run the query after setting the query def.
Perhaps a DoCmd.OpenQuery or DoCmd.Transferspreadsheet are in order depending on how you wish to see the results.
This is solved. Works great.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks