G
Guest
I have a People form that allows editting of a specific record in the People
table. I would like to add a control button that opens up the matching
Volunteer Form (based on the Volunteer table). If there is no volunteer
record for this individual, I'd like the control button to open a new record
and set the value of the related field (People ID).
Ideally, from the People form, if a volunteer record exists for this person,
I'd like the command button to read "Volunteer Record" and if not, "Add as
Volunteer". But since the People form data source is the People table, I
don't know how I could check the Volunteer table for this information. I
tried changing the data source for the People form to a query that includes
both the fields from the People table and Volunteer.[People ID] and
Volunteer[Volunteer ID]; however this messes up my button on my Household
form that initally opens the People Form.
How can I set up this command button?
thanks, Amanda
table. I would like to add a control button that opens up the matching
Volunteer Form (based on the Volunteer table). If there is no volunteer
record for this individual, I'd like the control button to open a new record
and set the value of the related field (People ID).
Ideally, from the People form, if a volunteer record exists for this person,
I'd like the command button to read "Volunteer Record" and if not, "Add as
Volunteer". But since the People form data source is the People table, I
don't know how I could check the Volunteer table for this information. I
tried changing the data source for the People form to a query that includes
both the fields from the People table and Volunteer.[People ID] and
Volunteer[Volunteer ID]; however this messes up my button on my Household
form that initally opens the People Form.
How can I set up this command button?
thanks, Amanda