View Single Post
  #24  
Old February 1st, 2009, 06:13 PM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Paul
external usenet poster
 
Posts: 68
Default navigating to different records in a read only form

Thanks for your reply, Tina.

I did think of putting the combo box in a subform, but using Dirk's
suggestion of setting AllowEdits = True in the combo box's Enter event seems
to be working. Even if it were in a subform, I'd still have to check every
new record to see if the user is authorized to edit it.

Ok, full disclosure - there's another reason I wanted to avoid putting the
control in a subform. I'm lazy, and every time I try put a subform
camoflagued as a single control into a main form, I end up spending about 20
minutes wrestling with size and placement of the subform control to get it
just right for appearance's sake. So from that standpoint, it's easier to
just Allow Edits when you enter the combo box, and you're done with it.

Marsh has raised a concern if the record is Dirty, so I'm going to ask him
about that over in the other thread.

Paul