Data Entry Property Keeps Changing

[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

 

[Andi Mayer]

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

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

then you save the forms properties, use acSaveNo

 

[Guest]

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!