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

On Tue, 8 Feb 2005 06:33:08 -0800, "DBAM"
<(E-Mail Removed)> wrote:

>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
---
If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
MW

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!

"Andi Mayer" wrote:

> On Tue, 8 Feb 2005 06:33:08 -0800, "DBAM"
> <(E-Mail Removed)> wrote:
>
> >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
> ---
> If you expect an answer to a personal mail, add the word "manfred" to the first 10 lines in the message
> MW
>