I have a combo box on a form used to lookup records.

It seems that in order for this combo box to work, I must set Allow
Edits to Yes, making the entire form (minus locked records) editable.

I only want records to be editable, however, if the user presses a
command button.  I tried some VBA coding to modify the RecordsetType
upon a click of an 'edit button.'  This, however, didn't work well and
I figured there's a simpler way.

Thoughts?

1.    Allow a combo box to function on a form without the ability to edit/
change a record.
2.    create a command control to set allow edits to yes upon click.
3.    I'm assuming you would then add code to the AfterUpdate and
OnCurrent events setting allow edits to no.

alex