record becomes read only after updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello all,

this is what I am trying to do. I have an orders form that my employes use
for entering new orders. I want the users to be able to enter the form
without having to enter a password to enter a new record, but only if they
wanted to edit a record... is this possible? if so can someone point me in
the direction that I need to go?

Thanks,

Brook
 
hello all,

this is what I am trying to do. I have an orders form that my employes use
for entering new orders. I want the users to be able to enter the form
without having to enter a password to enter a new record, but only if they
wanted to edit a record... is this possible? if so can someone point me in
the direction that I need to go?
Click to expand...

I'd suggest setting the form's Allow Additions property to True, and
Allow Edits to False.

Put a command button on the form to switch the AllowEdits property to
True, with a password (I think you got the instructions for this in
another thread); switch the AllowEdits back to False in the Form's
AfterUpdate event.

John W. Vinson[MVP]
 
Thank you for the help... that is exactly what I was looking for... yes I did
get the password option in the other thread...

If I could ask one more quesiton of you... is it possible to have it set up
so that I double click on any of the form fields it can ask me for a password
for editing?

Brook
 
John,

One thing that I have noticed while getting this set up with your options
you told me about.. is that if I close my form then go back in, I don't see
any of the records from my table? I am able to add a new record, but can't
see the other 50 records in my orders table?


Any suggestions?

Brook
 
John,

One thing that I have noticed while getting this set up with your options
you told me about.. is that if I close my form then go back in, I don't see
any of the records from my table? I am able to add a new record, but can't
see the other 50 records in my orders table?
Click to expand...

Sounds like you set the Data Entry property to True (instead of, or in
addition to, the Allow Additions).

John W. Vinson[MVP]
 
Back
Top