update a table when inner join is used

B

bindurajeesh

I have a subform on a form that is not bound. The subform has
SELECT tblWellnessActivity.ActivityType,
tblWellnessActivity.MinutesOfActivity, tblmember!FirstName & " " &
tblMember!LastName AS Name, tblWellnessActivity.MemberNumber
FROM tblWellnessActivity INNER JOIN tblMember ON
tblWellnessActivity.MemberNumber = tblMember.MemberNumber
WHERE
(((tblWellnessActivity.MemberNumber)=[forms]![frmWellnessCheckin]![cmbMemberName]));
as record source. when i hit a button on my main form it pulls the correct
data in the subform but i cannot make changes to the data in the subform. I
am thinking that it is the inner join that is giving me the problem. Would
there be a work around? Thanks.
 
Top