Populating from one field to another

[Guest]

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

 

[Guest]

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

 

[Guest]

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