Combo Box Data Entry and Display

[Samantha]

I'm trying to utilize one form (bound) to both display information and for
data entry (I'm not sure if this is the best way from a design perspective?).
It displays and collects detailed information about a product's information
based on the serial number.
My problem is with the combo box that displays the unit's Status. The Combo
box's datasource is from a table of Status options. I want the datasource to
display a limited UnitStatus (eg, "CLOSED" is not displayed because I don't
want the user to be able to change the unit stats to Close on this screen)
But on the other hand, I do want to to display the saved UnitStatus (even if
it is closed) with the Combo box. It can not do that now. My query on the
datasource excludes the "CLOSED" from the list. Is there a better way to
handle this?
Any advise is very much appreciated.

 

[Larry Daugherty]

The "Closed" field must be in the query for the combobox in order for
it to be displayed in the combobox.

HTH

 

[Samantha]

Thanks Larry for your quick response. That was what I thought also.
So, is there a better method of handling this situation where we need to use
the form to both enter restricted data and yet to display all, unrestricted
data?
Thanks.
Samantha