Combo Box Data Entry and Display

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Samantha - 14 May 2008 00:16 GMT

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.

Reply to this Message

Larry Daugherty - 14 May 2008 11:39 GMT

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

HTH

Signature

-Larry-
--

> 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?).
[quoted text clipped - 9 lines]
> handle this?
> Any advise is very much appreciated.

Reply to this Message

Samantha - 15 May 2008 20:16 GMT

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

> The "Closed" field must be in the query for the combobox in order for
> it to be displayed in the combobox.
[quoted text clipped - 23 lines]
> > handle this?
> > Any advise is very much appreciated.

Reply to this Message