Mark A Matte
markamatte at hotmail.com
Mon Mar 30 11:05:31 CDT 2009
Susan, > Donna, as a rule, a combo box populated with a UNION isn't bound. Why can't you use a UNION as a rowsource to a Bound combo box? ...or did I misunderstand your post? I understand the second part about updating the source tables of the combo with a function. Thanks, Mark A. Matte ---------------------------------------- > From: ssharkins at gmail.com > > 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... _________________________________________________________________ Express your personality in color! Preview and select themes for Hotmail®. http://www.windowslive-hotmail.com/LearnMore/personalize.aspx?ocid=TXT_MSGTX_WL_HM_express_032009#colortheme