Copy data from one table to another when for a specific record when a form field has been updated

[Pure Salt]

I have totally confused myself & now can't get my brain in gear!!

I have a table with 'Received Date'. This is linked to another table by 'Purchase Order'.

When I enter the 'received date' in my form, I would like it to automatically update a different table.

[Homegrownandy]

How is this data related to one another? what is the reason for the update? Do you have a screenshot of this relationship maybe? What info do you want to update?

[ranman256]

Append query.
the source ffield uses the key to get the record,then add to the target table.

[Homegrownandy]

I suspect he wont need to move any data at all. If the reason for separating it is just that (to have it separated) I'm sure you can do that on record level and have them all in one table.

[Pure Salt]

Thanks ranman256. Can you give me some more info as this is where I'm getting stuck.

I created an append query to update the record I was in - seemed to work fine, but when I checked the table the data hadn't transferred.

[Homegrownandy]

append query's don't update they add new records. did you press run on the append or view?

[Pure Salt]

Sorry, did say I had got myself into a muddle!!

Its an update query (not append). It tells me I'm about to update a record, but when I check it hasn't.

[Homegrownandy]

append will add a new record to the new table If that's what you want. or is it a specific field you want to update?

[Pure Salt]

It's a specific record I need to update

[Pure Salt]

Sorted - run the query back to front & it works!!!