I am creating a DB of events. There will be multiple eventsat a given time. The attendees to the event will be selected in another DB andexported to excel. The excel spreadsheet will be imported to the new DB andwill create a table with all the intended attendees. Each event will have anexact table design with specific attendees. The table will contain ‘EventId’, ‘EventName’, ‘AttendeeId’, ‘AttendeeName’ and ‘NbrAttending’.As required each will need to be updated or a roster printed. After the eventis over the table will need to be deleted. I’m thinking a form with a list boxof events from which to select the one to be dealt with. Also a button toselect which of the update, delete or print options to be taken.
With a single form for each option, I am a t a loss as tohow to change the record source based upon the selection made in the list box.
Or is there a better way to address this challenge.
Any thoughts will behelpful, thanks.