Recent content by Mierin

AH HA! I write the entire SQL query in VBA and assign to the RowSource! Thanks for sticking with me, jdraw. That is exactly the switch I needed flipped in my brain. The support article is most appreciated for syntax reference. I really need those cancan lady emojis to express my joy...:D...

Sadly, I cannot post the database. As mentioned in my original post, it is contractually prohibited. Can you just write a sample of how to call a string written in VBA into a SQL query?

Thank you, but that doesn't actually answer my question at all. I need to be able to select or not select any/all of the comboboxes. If I use this method, then none of the comboboxes populate until selections are made in all comboboxes. I tried it. I even added in columns in the query...

Sorry if I have not been clear. I have a filter on the whole form that is working. It takes the selections from the dropdowns and filters the form results accordingly. (That is what the code I posted in response to Ranman256 is.) My question is regarding RowSource. I would like to make the...

Thanks, jdraw. I think we are closing in on it. That is exactly what I am not understanding. How do I make the RowSource use the WHERE clause? If I use WHERE strFilter, it pops up a box looking for a strFilter value. Are you saying I would populate a non-visible field on the form with the...

Thank you, Ranman256. That is similar to how I currently have the form filter written, but I cannot see how would I get that to apply to the RowSource queries and not the form in general. It certainly isn't applying to my RowSources now, though it does filter my form correctly. Shortened...

Hello all, I am not even sure if I can do what I am trying to do, but it feels like it should be possible. I have a form that is showing 3 pieces of equipment and their attributes. The source of the data is from a query that links together a dozen different tables. The form results filter...