Recent content by nichojo

Cool, I'll give that a shot! Thanks!

This is the logic for populating a combo box. Even if I don't execute the rest of the logic and just simply populate a box, I get the error so I think its in here: Let's see here: Dim dbCurr As DAO.Database Dim rs As DAO.Recordset Dim SQL As String With Me.cmbRole For...

Thanks for the quick reply. However that doesn't stop the error - I put it in the onload of the form.

I have created a very complex form that displays query results as drop downs and does some basic data manipulation (not creation) as a result. When I close the form I get an error related to the index or primary key not found and I would like to suppress this error as it isn't actually relevant...

Thank you all for your replies - I'm going over your solutions now.

What is the easiest way to filter a list of all values that repeat? ie: A, A, B, C, D, D, E turns into B,C,E. I'm guessing I have to do some kind of count but I'm not a VBA master and don't know the slickest way to do this. I bow in your VBA expertise. Thanks!

That did it, thanks for your help!

Nice... didn't know I could pass functions as parameters. So theoretically all I need to do is set these variables as the common parameters and then run query z?

Hello everyone. I have a crazy situation that has me stumped. Query X and Y both take two identical values and use them as parameters to run. Query Z uses query X and Y as parameters. Query Z will be executed as a querydef in VBA. What is the best way to embed the necessary values into X and Y?