Form display selected table value from changing LOV in Access

[TennisBabe]

I have a form which is populated with a query and displays people. One field
is a COMBO box which looks up values from a query of available shirt sizes
from a separate table. The LOV works great and the values display. The
problem is that when I change the available shirt sizes (the LOV query looks
for all sizes with available=Yes). The LOV changes to the correct list. The
promblem is that I still want the previously selected values to display until
changes. The form query does NOT limit by available=Yes and the value is in
the query data. However, the form displays blank.
I tried a ControlSource with DLookup but was unsuccessful. Help please.

 

[Duncan Bachen]

I have a form which is populated with a query and displays people. One field
is a COMBO box which looks up values from a query of available shirt sizes
from a separate table. The LOV works great and the values display. The
problem is that when I change the available shirt sizes (the LOV query looks
for all sizes with available=Yes). The LOV changes to the correct list.

I was following you until here, where I got lost.
Your query returns the available shirt sizes.
Your combo box is based on the query, so it returns the same values.

The
promblem is that I still want the previously selected values to display until
changes.

Lost ya here. What are the previous selected values? Until what changes?

Could you give some examples?

The form query does NOT limit by available=Yes and the value is in
the query data.

Does "the form query" = the combobox query source?

 

[TennisBabe]

Hi Duncan! I have this question on the board twice (thought my first did not
go through). Can you look at "Combo display disappears if LOV list is
limited after selection" and see if I explained it better! thanks