View Single Post
  #13  
Old January 31st, 2009, 04:45 AM posted to microsoft.public.access.forms,microsoft.public.access.formscoding
Gina Whipp
external usenet poster
 
Posts: 3,500
Default MISTAKE: navigating to different records in a read only form

Paul,

You missed the subject line... I made a mistake. I ran into that problem.
So I created a Security Table 1 = Edit, 2 = View (or Read Only) and 13 =
System Administrator.

Depending on your Security Level and the Tag Property depends on what you
can do but it leaves the unbound combo box in operation. I suppose you can
even do it without worrying about the Tag Property of each field. I put it
in two place because while some might figure out the table they usually
ignore the tag property.

--
Gina Whipp

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

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

"Paul" wrote in message
...
Gina,

Can you tell me what VBA code you're using to keep the unbound control
from locking regardless of the value of the AllowEdits property? My
experience is that even if the Locked property of the Combo box is set to
"No," it will not select a new record in the form if AllowEdits is set to
yes.

Thanks

Paul