S
skk
Hi!
I have 2 tables (tblPerson, tblInviteesList)
Below is the SQL generated by query then I open the form based on the query.
The form is continuous form so, the user can see the list of the names all
at once and check off the who they want to invite. My problem is saving the
value "EventCode" & "FY" in the form. I want to get "EventCode" & "FY"
values from the previous screen where user typed in and save to the
tblInviteesList (prefill those 2 values and user only check off the Inivte
check box) and save to the tblInviteesList. Help and thanks!
SELECT tblInviteesList.InviteesID, tblInviteesList.ProtocalID,
tblPerson.Name, tblPerson.EMPL, tblInviteesList.FY,
tblInviteesList.EventCode, tblInviteesList.Invite
FROM tblInviteesList RIGHT JOIN tblPerson ON tblInviteesList.ProtocalID =
tblPerson.ProtocalID
WHERE (((tblPerson.EMPL)=[Forms]![frmInvitationEmpl]![cboEmpl]));
I have 2 tables (tblPerson, tblInviteesList)
Below is the SQL generated by query then I open the form based on the query.
The form is continuous form so, the user can see the list of the names all
at once and check off the who they want to invite. My problem is saving the
value "EventCode" & "FY" in the form. I want to get "EventCode" & "FY"
values from the previous screen where user typed in and save to the
tblInviteesList (prefill those 2 values and user only check off the Inivte
check box) and save to the tblInviteesList. Help and thanks!
SELECT tblInviteesList.InviteesID, tblInviteesList.ProtocalID,
tblPerson.Name, tblPerson.EMPL, tblInviteesList.FY,
tblInviteesList.EventCode, tblInviteesList.Invite
FROM tblInviteesList RIGHT JOIN tblPerson ON tblInviteesList.ProtocalID =
tblPerson.ProtocalID
WHERE (((tblPerson.EMPL)=[Forms]![frmInvitationEmpl]![cboEmpl]));