Hello fellow programmers,
I am trying to run an append/update query from code, a command button
on a form initiates the queries.
the format i am using is;
__________________________________________________ ___
SELECT "criteria"
FROM "criteria"
WHERE "criteria"
UPDATE/APPEND "field selections"
RecordSource "qryExample" = above text strings"
__________________________________________________ _____________________
When i am running a SELECT query in this manner it works fine with no
problems, and accepts the values of specified linked form fields.
This never works when doing an APPEND/UPDATE query. It can never find
the values of linked form fields, Access always asks for the parameter
value of the field(s) in question, or Access comes up with an error
3323 - No recordset. I am sure there are other people that have had
this problem.
What is the difference between Select queries and append/update
queries? the append/update queries never seem to be able to find
values in linked form fields.
Can anyone shed any light on this or point to a knowledgebase Item, or
even recommend a book focusing on this subject, I will go and buy it
now.
I have been for up 2 nights trying to acomplish this and now
considering suicide, please help.
Thanks In advance,
Aaron.