Populating from one field to another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grizz - 17 Nov 2006 07:36 GMT

My problem is that I have two linked (Not to each other) tables with
different field names for the same value (integer). My INSERT INTO table is
using a different field then the SELCET....FROM table. I am populating the
the SELECT....FROM table from combo boxes on the form which in turn are
getting the values from different tables. I guess what I am saying is how can
I force the value to be inserted from one table to another using different
field names? Should I be passing this as a stored string value?

Thank You

Reply to this Message

TonyT - 17 Nov 2006 11:31 GMT

Hi Grizz,

If the data you want inserting is already selected in your combobox just use;

"INSERT INTO myTbl (fldName) VALUES(" & Me.myCombobox & ") WHERE......"

TonyT..

> My problem is that I have two linked (Not to each other) tables with
> different field names for the same value (integer). My INSERT INTO table is
[quoted text clipped - 5 lines]
>
> Thank You

Reply to this Message

Grizz - 18 Nov 2006 03:37 GMT

TonyT

I will give this a try thank you, I really didn't fully explain what is
going on but this is the legit of it and I do appreciate your help.

Grizz

> Hi Grizz,
>
[quoted text clipped - 13 lines]
> >
> > Thank You

Reply to this Message