Read only

  • Thread starter Thread starter Charlie German
  • Start date Start date
C

Charlie German

I have a form that I would like to make read only, when I make the form read
only the lookup box that I have becomes read only too. Is there a way to keep
the lookup box useable and have the rest of the fields read only?
 
Charlie said:
I have a form that I would like to make read only, when I make the form read
only the lookup box that I have becomes read only too. Is there a way to keep
the lookup box useable and have the rest of the fields read only?
Click to expand...


Lock all the data controls in the form that you do not want
users to be able to change. If you also want to prevent
users from being able to tab or click on the locked
controls, then also set their Enabled property to False.
 
Charlie,

I had a similar question. It was:

I want to create an inquiry screen where the user can enter a person name in
a combo box, which is bound to the member name in the table.

I already have a data entry form. Ideally, I would like to have my data
entry form do double duty as both a data entry form and an inquiry form. If
I change the form's Allow Edits to NO, then I can not enter the member's name
in the combo box. I know I can set each field's lock property to "YES", but
my concern is if I add a new field I will forget to Lock it if the program is
run in display mode. (I pass the run type - Input or Display - in the Open
Args).


Is there a simple way to Lock all fields except my name combo box or am I
better off create a different form that only display data?


Jeanette Cunningham from Melbourne, Australia was kind enough to let me in
on this little trick:


One way round this dilema is to only set allow edits to true when the user
enters the combo used to find a member - use the Enter event. After user has
made their selection and is leaving the combo, use the Exit event of the
combo to set allow edits to false.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Back
Top