navigating to different records in a read only form

just to put my 2 cents worth in: going back to your very first post in this
thread, Paul, it sounds like you had the form allowing/not allowing edits as
you wished, and the only stumbling block was being unable to use an unbound
"combobox control to select different records" when AllowEdits was set to
No.

the simplest solution for this particular situation might be remove the
combobox control from the form, and add it to a new unbound form, then add
the original form to the new form as a subform. so you can set AllowEdits to
True/False in the subform, without affecting the performance of the combobox
control in the mainform. if you have VBA code behind the combobox control to
select records, you should be able to adapt it to work on the subform's
RecordSource. or you may be able to set the subform control's
LinkMasterFields property to the combobox control name, and set the
subform's related field as the LinkChildFields property, to pull the subform
record(s) you want.

hth


"Paul" wrote in message
...
Thanks for the sample code, Dirk. If I understand it correctly, it's a
good
way to control who can edit the records in a form if one group of users
can
edit all records in a form, and another group can edit no records in a
form.
I can use that in some situations, but in this particular one, I need to
check the users' authorization for each record.

This is a Project Management application, and I want the Project Manager
and
Team members to edit their own projects, but not other projects. I have
some forms where users can only see their own projects, but in this
particular form I want everyone to be able to see all projects, but only
edit the ones in which they are on the mamagement team. And so I'm
thinking
the best way to do that is to check their authorization status in the
following three events:

1. the form's Load event,
2. the form's OnCurrent event and
3. the selection combo box's Exit event

Does that make sense?

Paul