I have a database that generates surveys to send to employees
annually.
I've set up a progress log for the user, such that when the survey is
complete for a particular recipient, the user enters the completion
date.
Here's the table/query/form structure of the Log functionality:

Table: Logs
LogID Primary key.
fkSurveyRecipientID Foreign key, SurveyRecipients.
fldDateSent
fldDateReceived
fldDateFirstNotice
fldDateSecondNotice
fldDateThirdNotice

Query: q_Log
SELECT S.fldFirstName, S.fldLastName, S.fldEmail, L.fldDateSent,
L.fldDateReceived, L.fldSecondNoticeDate, L.fldThirdNoticeDate
FROM SurveyedRecipients AS S INNER JOIN Logs AS L ON
S.SurveyedManagerID = L.fkSurveyedRecipientID
WHERE S.fldNoSurvey=False;

Form: frmLog
Pulls first & last name, date sent, received, 1st notice, 2nd notice,
3rd
notice into a datasheet view (Dynaset). Record source is q_Log above.

Here's the question:
I don't want the user to be able to edit any data related to the
SurveyRecipient
table when using the log. Updates to the recipients are handled
elsewhere. I
just want the user to be able to enter the dates. Is there a way to
not allow
updates to one part of a join (SurveyedRecipients) and still allow
updates to the
other side (Logs)? Am I missing an easier way to do this? I'm in
A97.
I'm versed in VBA.

TIA,
Johnny