AddAllToList error

C

Chris Barry

I followed the instructions in "Q210290 - ACC2000 How to Add '(all)' to a Combo Box or a List Box Control", but I consistently get a "Type Mismatch" error. The line of code that appears to be generating the error is "Set RS = DB.OpenRecordset(C.RowSource, DB_OPEN_SNAPSHOT)". The combo box is Unbound on a form I'm using to set criteria in a query for use in a report. I have managed to use a Union Query to get "All" to appear in the combo box, but it does not allow all records from the query to pass through to the report. Can anyone help me with this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

AddAllToList() Function error 2
Brackets in A Query Criteria From a Combo Box/Text 2
Search combo box 2
Error 3021 but records exist 0
Column Orders 1
7 Combo Boxes in a Form with "All" option 0
Implementing public VBA function in Access 2003, passing multiple parameters 5
Error 2147352567 2

Top