Display current value in field even if option is not available in combo droplist

[moishier]

I have a datasheet that pulls from a query, and one of the fields is a combo drop list. That combo has a filter on the row source so it does not display all the possible values that can be contained in the field.

The issue is that the datasheet will now display a blank field for those entries that are filtered out of the combo list. Is there any way to still display the current value from the query in the field and not have a blank field?

Note: the combo list returns two columns (ID and description), it is bound to column 1, and column 1 is not displayed via the column widths property, so only column 2 (the description) is shown.

Is this datasheet set up incorrectly?

 

[moishier]

The default record source is NOT filtered, and there is a record source on this specific combo box that IS filtered. Because of this filter it's affecting display of the values displayed in the datasheet when the stored results do not match the filters - the field is blank. When I remove the filter on the combo box record source the field shows the result.

 

[sneuberg]

It sounds like the row source of you combo box is a filter version of the record source of the form. That doesn't make sense to me. Usually you use a combo box to select values from some other source. Please tell us what tables are involve in this, what the fields are and what you are trying to accomplish.

 

[CJ_London]

I suspect the OP is talking about cascading combo's

If so, take a look at this suggestion I posted a while back

http://www.access-programmers.co.uk/forums/showthread.php?t=275155

It provides a similar solution to that suggested by Unc