"Marshall Barton" wrote in message
...

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.


I've always done it the way Marsh suggests, but recently it occurs to me --
probably suggested by someone else -- that it might be simpler to just set
AllowEdits = True in the combo box's Enter event and set AllowEdits = False
in the combo's Exit event. I haven't tried this in any practical
application, but it works in a quick test, and might be handier if the form
is only going to be read-only for some users, not all.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)