Hi Stuart,
Just include the table you are updating from in your query duh!
Regards,
Stuart
--- In MS_Access_Professionals@yahoogroups.com, "Stuart Luckman" <stuartluckman@...> wrote:
>
> 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
>
__._,_.___
.
__,_._,___
Tidak ada komentar:
Posting Komentar