Combo Box -display all, select only current.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box which allows a user to select only current items. The
problem is when historical data is viewed any obsolete data is not displayed.
The data is seen as a null field since the value doesn't meet the criteria.
Is there a way to have a combo box display all items but only allow for
current items. I'm trying to get around having a seperate form for data
entry and display, since many records are added at one time. Any assistance
will be appreciated.

Justin
 
I have a combo box which allows a user to select only current items. The
problem is when historical data is viewed any obsolete data is not displayed.
The data is seen as a null field since the value doesn't meet the criteria.
Is there a way to have a combo box display all items but only allow for
current items. I'm trying to get around having a seperate form for data
entry and display, since many records are added at one time. Any assistance
will be appreciated.

Justin
Click to expand...

One tricky way to do so is to carefully superimpose a textbox over the
text area of the combo box. You can base your Form on a query joining
to the combo's rowsource table and just display the field; or you can
set the textbox's Control Source to a DLookUp expression looking up
the field.

Set the textbox's Enabled = False, Locked = True, Tab Stop = No. The
combo's data will appear when you drop it down; otherwise the textbox
will show the historical data.

John W. Vinson[MVP]
 
I set it up and it works good. thanks

John Vinson said:
One tricky way to do so is to carefully superimpose a textbox over the
text area of the combo box. You can base your Form on a query joining
to the combo's rowsource table and just display the field; or you can
set the textbox's Control Source to a DLookUp expression looking up
the field.

Set the textbox's Enabled = False, Locked = True, Tab Stop = No. The
combo's data will appear when you drop it down; otherwise the textbox
will show the historical data.

John W. Vinson[MVP]
Click to expand...
 
Back
Top