Combo box source is Union Query but can't write to it

[CTOROCK]

I have a form where I have a combo box pulling names from a union query. I have the formed bound so I can auto populate the other relevant fields. However, when there isn't a match in the combo box I can't clear the fields and add a record to the query as it is a union query. How can I add a name to it and then have it selectable in the future? After the fields populate and more info is inputed I save the record by coding it through a save button going to another table. Can I unbound the form and do a multiple criteria search in the union query?

thanks in advance for your time

"The greatest risk, is not taking one."

 

[Remou]

You can update the table or tables that the query is based on with SQL run in VBA.


You can unbind the form. You may wish to read:

http://www.tek-tips.com/faqs.cfm?fid=5497

Although it refers to building a report, you can use the code to build an SQL string.