Combo display disappears if LOV list is limited after selection

[TennisBabe]

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!

 

[Douglas J Steele]

Is this on a continuous form?

Check http://www.fmsinc.com/free/tips.html#tip16foraccess for one approach
to solve the issue.

 

[TennisBabe]

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?

 

[Douglas J Steele]

Did you check the reference I suggested?

You might also want to check
http://groups.google.com/group/micr...read/thread/862ab458e8f6bad6/e7bde6af0f31e1c8