Form will not let me create a combo box?

[MariaL]

I have a form that displays records from a union query. I added a subform to show addition records from another table. When I create my combo box to "Locate a record based on value in combo box" it will let me pull over the field names that I want to show in the list. But, when I click on next I get the following error:
"Method 'Open'of object'-Recordset'failed.
I create these all the time. The only difference is the form is looking at a UNION query. Any suggestions?
Thank you!

 

[OhioSteve]

I don't have a specific answer for you, but I do have a general comment. Union queries are just two data sources, smooshed together. They are not the most elegant things. They are not used frequently. So, its not surprising that some Access objects may not work ideally with this sort of query.