[MS_AccessPros] Update backend table from frontend table Access 2007

 

Hi all,

I'm trying to run an Update query which gets its values from a frontend temp table to a backend table.

When I run it it shows a parameter input box asking for the frontend temp table fields.

This is the SQL for the Update query:

UPDATE Potting_Record SET Potting_Record.Location_ID = [Stocktake_Temp]![ID_Loc]
WHERE (((Potting_Record.ID_Potting_Record)=[Stocktake_Temp]![ID_Potting_Record]));

Any idea what I am doing wrong?

Thanks,
Stuart

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 10
• New Files 4

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___