Using a combobox in a subform

G

GAKDEV

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?
 
G

GAKDEV

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to remove error from conflicting code 0
Dynamic Naming of Form Button 3
Clearing combo boxes and a text box 2
Keeping info in combobox 2
Unremovable horizontal scroll bar on subform 1
Creating a Search using a combo box and then creating a report. 4
Combo boxes in excel 6
requery a combobox in a continuious form subform 1

Top