Combo Box Will Not Display Value in Existing Records

[Amy E. Baggott]

I have a booth assignment system that is set up for a mult-hall show. The
form contains two linked combo boxes. The first brings up a list of halls
for the current show, stores the hall ID, and displays the hall designator
("N", "C", etc.). The second brings up a list of booths that are linked to
the hall that was selected, stores the booth ID and displays the booth
number. The only problem is that this form is set up so that when the sales
guy looks up a company's assignment, it should display any assignments they
currently have and allow him to "remove" that assignment (actually, he just
clicks a checkbox which tells the person actually modifying the order to take
that booth off the order and put in the new one while still keeping the
history of the old one) and/or to add a new booth assignment. The problem
arises when an exhibitor has booths in multiple halls. The second combo box
displays fine for any record that has the same hall as the first record in
the group, but if the first booth is in Hall C and the second booth is in
Hall N, the second booth number does not display. The combo box on the
second record ends up blank. If I go into the second record and click
Records, Refresh, then the second record displays perfectly and the first
record has a blank booth number. I suspect it is because of the filtering of
the second combo box, but is there a way around it?

 

[Sean Timmons]

Sounds like you just need to put in a Requery on the combobox. On your first
combo box, I'd select On Change, then go into code. Have the code say
combobox2.requery.

 

[Amy E. Baggott]

I already have a requery built into the On Update of the Hall combo box. The
problem is not when I enter the information in a new form. That works fine.
It's when I view the records later. I don't want my users to have to go into
each record every time they (or I) want to see what an exhibitor's been
assigned to. At the same time, I'd like them to be able to use the same
continuous form to change an exhibitor's assignment or add a new booth
assignment to that exhibitor.