Susan Harkins
ssharkins at gmail.com
Mon Mar 30 10:44:49 CDT 2009
Donna, as a rule, a combo box populated with a UNION isn't bound. That means you'll have to call a function that updates the appropriate table, using ADO or SQL, your choice really. Do you need help passing the value or what? Susan H. > Hi guys! > > I really am stumped on this one, and could use a little help... > > I am trying to combine two tables using a UNION query that come from > different databases. This appears to be no problem. I will be using this > in a combo-box. My problem comes when Not in List happens, as I will need > to add rows to only one of these tables. I'm having difficulty getting to > the right database table, adding it to the combo-box, and getting back to > the form. This is probably way simple, but I'm having a major brain > burp...