Combo box updates on a 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

 

[Tom van Stiphout]

On Sat, 6 Jun 2009 04:44:25 -0700 (PDT), Jeff <[email protected]>
wrote:

I don't understand the part where you write "it only shows
members already selected"; this dropdown should simply show all
members from the Members table.

To add new ones, use the NotInList event: someone enters a new name
and you open a modal dialog for the user to enter that new member.
Then you return the correct value so Access automatically requeries
the dropdown and tries again.

-Tom.
Microsoft Access MVP