Dropdwon List

T

Tango

This may be a silly question but i have a dropdown list that uses a query as
its list row source. the query has a name & id field. I would like to make
this field read only. How would i do this. (There are some fields that are
updateable)
thankyou
todd
 
S

Steve Schapel

Todd,

The controls have a Locked property, which you can set to Yes. It is
difficult to imagine how this would be applicable to a combobox... what
is the purpose of having a drop-down list if you can't select from it?
 
T

Tango

Thanks Steve,

Your right, it doesnt need to be a dropdown box, i would prefer to use a
Bound Span control however i cant work out how to use the control to display
a name that resides on another table where this field displays a number.
(like a combo box where the display is different from the bound field) On
fact i have a query that merges the first name & last name that i would
prefer to use.

Look forward to your comments.

Todd
 
S

Steve Schapel

Todd,

One option would be to use an unbound textbox with its Control Source
set to something like...
=DLookup("[FirstName] & ' ' & [LastName]","AnotherTable","[PersonID]="
& [PersonID])

Another option would be to use a query for the record source of the
form, and include the "another table" in this query, appropriately
joined, and then you have the lookup data directly qavailble for display
on the form.

If you need more specific help, please psot back with more details, with
examples, of exactly what you want and what you are trying to achieve.
 
Top