Assign a value to a field from one table to a field in another

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lcross23@gmail.com - 10 Mar 2006 02:18 GMT

I have a Access database that I inherited, and I do not want to alter
the inital table or forms. I am adding a table and I want to insert a
new record and assign fields of that record with some data from the
first table with data from the first table in the second on a button
click. I am looking for some guidence on how to do this.

Reply to this Message

Deborah Jean - 10 Mar 2006 12:04 GMT

You could try an append query
http://office.microsoft.com/en-us/assistance/HA011860631033.aspx#1

> I have a Access database that I inherited, and I do not want to alter
> the inital table or forms. I am adding a table and I want to insert a
> new record and assign fields of that record with some data from the
> first table with data from the first table in the second on a button
> click. I am looking for some guidence on how to do this.

Reply to this Message