J
Jeff
I have a subform whch is aborting when I try to add it to a form.
This is a many to many relationship between an Event (key EventID) and
a Volunteer (key Contact ID). There is a table that ties these two
tables together. It contains the Event ID, the Contact ID, and a
comments field.
I'm trying to add a list of all Volunteers to an Event form. The list
of Volunteers is in a subform.
The subform has 3 fields
Contact ID (key field) Combo box.
First Name
Last Name
If there are table entries tying the Event and Volunteer together, the
Contact ID is protected and the first and last name appear.
If there are no entries the Contact ID is filled in with the list of
Volunteers and a volunteer can be selected.
Everything seemed to be fine until I added the query to populate the
list of volunteers for the Contact ID field and now it aborts
everytime I try to do something with it. Have I confused ACCESS or is
there an issue with this?
Thanks
This is a many to many relationship between an Event (key EventID) and
a Volunteer (key Contact ID). There is a table that ties these two
tables together. It contains the Event ID, the Contact ID, and a
comments field.
I'm trying to add a list of all Volunteers to an Event form. The list
of Volunteers is in a subform.
The subform has 3 fields
Contact ID (key field) Combo box.
First Name
Last Name
If there are table entries tying the Event and Volunteer together, the
Contact ID is protected and the first and last name appear.
If there are no entries the Contact ID is filled in with the list of
Volunteers and a volunteer can be selected.
Everything seemed to be fine until I added the query to populate the
list of volunteers for the Contact ID field and now it aborts
everytime I try to do something with it. Have I confused ACCESS or is
there an issue with this?
Thanks