Read-only form

R

Rod

I have created a new query, which simply shows me people scheduled for a
meeting from today forward:

SELECT tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY,
tblCandidates.AREA_CODE, tblCandidates.ID, tblCandidates.INPUT_NUMBER,
tblCandidates.NUMBER, tblCandidates.CANDIDATE, tblCandidates.DNC,
tblCandidates.CALLED_ON, tblCandidates.CALL_RESULTS,
tblCandidates.CONFIRMATION_DATE, tblCandidates.RETURNED_CALL,
tblCandidates.ATTENDED, tblCandidates.[NO_SHOW_FOLLOW-UP],
tblCandidates.COMMENTS, tblCandidates.[CO RESULTS], tblCandidates.STAR
FROM tblCandidates
GROUP BY tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY,
tblCandidates.AREA_CODE, tblCandidates.ID, tblCandidates.INPUT_NUMBER,
tblCandidates.NUMBER, tblCandidates.CANDIDATE, tblCandidates.DNC,
tblCandidates.CALLED_ON, tblCandidates.CALL_RESULTS,
tblCandidates.CONFIRMATION_DATE, tblCandidates.RETURNED_CALL,
tblCandidates.ATTENDED, tblCandidates.[NO_SHOW_FOLLOW-UP],
tblCandidates.COMMENTS, tblCandidates.[CO RESULTS], tblCandidates.STAR
HAVING
(((tblCandidates.CORP_OVERVIEW)<>IsNull([tblCandidates.CORP_OVERVIEW]) And
(tblCandidates.CORP_OVERVIEW)>=Date()) AND
((tblCandidates.CANDIDATE)<>"Test1" And (tblCandidates.CANDIDATE)<>"Test2"))
ORDER BY tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY DESC ,
tblCandidates.AREA_CODE;

When I run the query it shows me what I would expect, however, when I build
a form based on this query, I cannot update any of the fields. The following
form properties are are set to yes:
Allow additions, deletions, edits.
Data entry is set to no.

After looking at this for an entire day I have run out of options. Your
thoughts would be appreciated.

Rod.
 
M

Marshall Barton

Rod said:
I have created a new query, which simply shows me people scheduled for a
meeting from today forward:

SELECT tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY,
tblCandidates.AREA_CODE, tblCandidates.ID, tblCandidates.INPUT_NUMBER,
tblCandidates.NUMBER, tblCandidates.CANDIDATE, tblCandidates.DNC,
tblCandidates.CALLED_ON, tblCandidates.CALL_RESULTS,
tblCandidates.CONFIRMATION_DATE, tblCandidates.RETURNED_CALL,
tblCandidates.ATTENDED, tblCandidates.[NO_SHOW_FOLLOW-UP],
tblCandidates.COMMENTS, tblCandidates.[CO RESULTS], tblCandidates.STAR
FROM tblCandidates
GROUP BY tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY,
tblCandidates.AREA_CODE, tblCandidates.ID, tblCandidates.INPUT_NUMBER,
tblCandidates.NUMBER, tblCandidates.CANDIDATE, tblCandidates.DNC,
tblCandidates.CALLED_ON, tblCandidates.CALL_RESULTS,
tblCandidates.CONFIRMATION_DATE, tblCandidates.RETURNED_CALL,
tblCandidates.ATTENDED, tblCandidates.[NO_SHOW_FOLLOW-UP],
tblCandidates.COMMENTS, tblCandidates.[CO RESULTS], tblCandidates.STAR
HAVING
(((tblCandidates.CORP_OVERVIEW)<>IsNull([tblCandidates.CORP_OVERVIEW]) And
(tblCandidates.CORP_OVERVIEW)>=Date()) AND
((tblCandidates.CANDIDATE)<>"Test1" And (tblCandidates.CANDIDATE)<>"Test2"))
ORDER BY tblCandidates.CORP_OVERVIEW, tblCandidates.PRIORITY DESC ,
tblCandidates.AREA_CODE;

When I run the query it shows me what I would expect, however, when I build
a form based on this query, I cannot update any of the fields. The following
form properties are are set to yes:
Allow additions, deletions, edits.
Data entry is set to no.


That query is a Totals type query, which are never
updateable.

Since the query does not use any aggregate functions, I can
see no reason for you to use a Totals query. Try making it
a standard Select query.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top