Search results

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...

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!

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?