Combo box Not Displaying Contents When the Form is Reopened

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

Guest

I have a form with a combo box based on a query that filters based on a text
box on the form (i.e., if category = x, it shows only those subcategories
related to x). It works beautifully except for one thing: when I reopen the
form, the value of the combo box does not display for saved records, even
though the value is there in the table the form is based on. I have it set
up so that when the text box is updated it requeries the combo box. If I
don't do that, I either get no records at all or an unfiltered list of
records. Help!
 
If you have the value of the text box integrated into the RowSource of your
combo box, then perhaps the text box is null when opening the form, and the
combo box is attempting to show only those records where that field is null.

To fix this, you can adjust the criteria lines in your RowSource query of
the combo box to account for when the combo box is null and when it is not
(i.e. only apply the filter when the box is not null)
 
Back
Top