Error with data entry property

[hoose]

hi everyone

I'm a little confused about an error I'm getting

code

Do.Cmd.OpenForm "Introduction"
Me.DataEntry = False
DoCmd.GotoControl "IDselectBox"

The above code is producing a run-time error '2109' "There is no field named IDselectBox in the current record"

However, if i comment out the Me.DataEntry line, everything works ok, except the form is opened in data entry mode which i don't want.

What I want to do is have some users open the form in data entry mode and other uses open the form in non data entry mode. Is this possible? I'm pretty new at this.

Dan

 

[gol4]

Looat at the open form method a little closer and you will see it has argument to hadle that

the data mode argument

one of the choices

acFormAdd
acFormEdit
acFormPropertySettings (default)
acFormReadOnly

docmd.OpenForm "Introduction",acNormal,,,acFormAdd docmd.OpenForm "Introduction",acNormal,,,acFormedit

 

[hoose]

oh i see

thanks for the info

it's working fine now

do you know why i can't do what i was doing before?

dan