Paul,

Put an Unbound Combo Box on the form, this will not lock so all users can
use it as a look-up box but the ones that can edit will have no difficultly.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"Marshall Barton" wrote in message
...
Paul wrote:

When you have a read-only form, (one whose "Allow Edits" property is set
to
"No"), how do you get a record selection combo box to work in that form?

I have a form that uses a record selection combo box to select different
records. For some of my users, I have VBA set Allow Edits to "Yes," and
for
others, "No." But when it's set to "No," the record selection combo box
won't work. How do you navigate to different records when you have a read
only form, if the combo box won't work?


Instead of using AllowEdits, set the Locked property of all
controls except the combo box. This can easily be done by
holding down the Shift key and clicking on each of the bound
controls.

--
Marsh
MVP [MS Access]