A form containing 5 list boxes, Event, Badge, LastName, FirstName and attendees. It also has two list boxes, LstEvent and LstVolunteers. LstEvent is populated from TblEvents form rrom which a particular event is selected. The second list box LstVolunteers is populated from TblAllEvents, which contains records from all events. Each event can have same name as other events. A selection from LstEvent will cause a requery and populate the LstVolunteers with only the names from the selected LstEvent. When selecting a volunteer in the LstVolunteers the five text boxes are populated. Giving an opportunity to change any of the fields.
With all the data updated on the form I am looking for a way to update that record in the TblAllEvents. I have tried the DoCmd.RunComman acCmd Save record with no success, I have tried to create an update query and can get nowhere with that.
It seems that the best way is the update query but I have miserably there.
There must be a reasonable way to save this record.
Any help will be appreciated.
Thanks