Change to form

[Jeff]

I'm modifying a client's existing form. The form show a single event
with many members attending. There is a many-to-many relationship
between Events and Members and there is a relationship record between
the two tables.

Event
EventID
Event Name

tlbAttendees
EventID
MemberID
Comments

Members
MemberID
Last Name
First Name

Currently, they list the members in a combo box, but it only shows
members already selected with no way to add/delete members.


1) Is there a way to show all the members and highlight or somehow
emphasize the ones who have already been selected?

2) How do I allow updates to the members via this form?

Thanks.
Jeff

 

[Mike Painter]

I'm modifying a client's existing form. The form show a single event
with many members attending. There is a many-to-many relationship
between Events and Members and there is a relationship record between
the two tables.

Event
EventID
Event Name

tlbAttendees
EventID
MemberID
Comments

Members
MemberID
Last Name
First Name

Currently, they list the members in a combo box, but it only shows
members already selected with no way to add/delete members.


1) Is there a way to show all the members and highlight or somehow
emphasize the ones who have already been selected?

2) How do I allow updates to the members via this form?

Not nearly enough information.
What member information do you want to update?
How did the form get the members to start with?
When you say add/delete, do you mean add/delete to an event or get rid of
them completely?

I would probably have an event form with a member attending subform and add
members from the event form with a combobox.
The combobox query could be set to display only the members not on the list.

 

[Jeff]

What member information do you want to update?

I just want to add and remove members from the list in the combo box.

How did the form get the members to start with?

This is currently being done with a 1 time conversion to the database.
But on-going changes should be completed via this form.

When you say add/delete, do you mean add/delete to an event or get rid of
them completely?

I would like to add and delete members to the event.

I would probably have an event form with a member attending subform and add
members from the event form with a combobox.
The combobox query could be set to display only the members not on the list.

So 2 combo boxes? 1 tied to a subform of existing members and a 2nd
unbound combo box with members not on the list?

 

[Mike Painter]

I just want to add and remove members from the list in the combo box.

This is currently being done with a 1 time conversion to the database.
But on-going changes should be completed via this form.


I would like to add and delete members to the event.


So 2 combo boxes? 1 tied to a subform of existing members and a 2nd
unbound combo box with members not on the list?

No, one combo box and a subform showing who attended. In a similar
application I just have the combo box in the subform to look up the people I
want to add to the list.
I don't filter that list and have no problem adding names even with a couple
hundred of them