Locked combo box

A

Andrew Black

I currently have a locked combo box (ie I don't want the user to be able
to change the data). Is there are way either

- removing the pull down from the combo box (I realise this removes
the "comboness" of the box

- adding a control that does the lookup (ie taking the value from a
field in the record and looking the value to display up
in another table).

Cheers
 
A

Arvin Meyer

Andrew Black said:
I currently have a locked combo box (ie I don't want the user to be able
to change the data). Is there are way either

- removing the pull down from the combo box (I realise this removes
the "comboness" of the box
Click to expand...

Both Lock and disable the combobox so that it cannot get the focus. Cover
the arrow box with a small box matching the form's background color.
- adding a control that does the lookup (ie taking the value from a
field in the record and looking the value to display up
in another table).
Click to expand...

You can use DLookup if it's a textbox, or, if it's a combo, just use the
column property of a combobox:

Forms!MyForm!MyCombo.Column(2)

is the third column in a combo. You can set the value of a textbox to this
in the combo's after update event.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top