Data Entry Property Keeps Changing

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

Guest

Help! I have designed a small database for two clients and all is going
quite well with one exception. One of the main forms they use for looking up
records was designed with the data entry property set to "No". For some
reason, there are times when the form opens with this property set to "Yes".
This usually results in a panic call from the client asking for help; and me
talking them through the properties window to change the data entry back to
"No". I have several other clients interested in this database, but I
hesitate to install it for them until this issue is resolved. Does anyone
have a suggestion? I could sure use some ideas! Thank you.

Debbi
 
Help! I have designed a small database for two clients and all is going
quite well with one exception. One of the main forms they use for looking up
records was designed with the data entry property set to "No". For some
reason, there are times when the form opens with this property set to "Yes".
This usually results in a panic call from the client asking for help; and me
talking them through the properties window to change the data entry back to
"No". I have several other clients interested in this database, but I
hesitate to install it for them until this issue is resolved. Does anyone
have a suggestion? I could sure use some ideas! Thank you.

Debbi
Click to expand...

do you use a docmd.Close acform,"FormName",acSaveYes ?

then you save the forms properties, use acSaveNo
 
Andi, Thank you. I had a feeling that I needed to address the form on
either open or close. I will give it a try today!
 
Back
Top