[AccessD] A little help, please

Hi Susan,

This appears to be what I might have to do.  Let me try working this out later today, and I'll get back to you if I have problems (...very possible, I'm afraid...).

Thanks to EVERYONE for your responses!  I'll let you know if I am successful.

Donna



-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins
Sent: Monday, March 30, 2009 11:45 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] A little help, please

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...

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

This e-mail message (including any attachments) is for the sole use of
the intended recipient(s) and may contain confidential and privileged
information.  If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination, distribution
or copying of this message (including any attachments) is strictly
prohibited.

If you have received this message in error, please contact
the sender by reply e-mail message and destroy all copies of the
original message (including attachments).