Using a combobox in a subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am re-doing a reservation system for a charity where peole can sponsor tables but have multiple name associated below. I need to be able to specify a room for the table. I am using a subform with a Combo Box in the header to select the room for the 1 to many individuals with the group. the Combo Box will put the correct value in the Room Code for the first record, when I move to the next record, the Combo Box is blank and the Room Code is not set. How do I keep the initial value that I set for the second and subsequent entries?
 
Some additional Info. I have been doing some research and I tried the code to set the value of the combobox in the afterupdate event. It doesn't work for me. I am using Access 2003, but the database is in Access 2000 format.
 
Back
Top