Help with my table relationships and list box

Hi,

I am trying to create a data entry form for users. I want part of this to be a list box that can have multiple selections. As it stands at the moment. I have a table for Event details called 'Event', a table for Universities called 'Universities' who may attend, and a table inbetween called 'Attending' to stop the many to many relationship by having the Event Id and University Id in. I don't know if this is correct? Could someone confirm correct table design?

If it is/isn't how can I add a list box to the event data entry form for multiple University selections to be made?

Thanks for looking.

re: Help with my table relationships and list box

Actually what I'm looking for is very similar to this I think:

Adding and populating a new record directly into a table using VBA

I'm no expert so I will see if this works.

re: Help with my table relationships and list box

Your table design is fine. The list box method will require vba to either work with a recordset or run sql commands. The other option is a form bound to Event containing a continuous subform bound to Attending with a dropdown where one can select a University.

re: Help with my table relationships and list box

Yeah, you're right! After getting confused with all the VBA stuff on the previous link, your continuous form solution is much better. Works like a charm!