Combo display disappears if LOV list is limited after selection

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

Guest

I have a combo with a query LOV, it's a selection of T-shirt sizes from a
table. Works fine and can select values. But I want to have the LOV get
smaller as the sizes are not available. So I have the LOV query based on
More=Yes. The LOV is limited fine. My problem is the previously selected
sizes are now blank even though the value is in the form query. It will not
display! Help!
 
Yes, it is a continuous form with only one combo box. The combo box works
great (the LOV is a query from a table). The continuous form pulls all
people from a table. The one combo box is a selection of T-shirt sizes. I
have the LOV query to display all sizes where a field=Yes. When I change a
size to =No (now unavailable), the LOV in the form now displays the reduced
list, which is good. However, the people who had previously selected the
field which was =Yes and then now =No, the combo box displays a blank. The
form query still has the correct value listed, it just does display now. I
want the previously selected value to display and the new selections to be
limited. The sizes will reduce until all gone. How to display?
 
Back
Top