can't keep form from opening on new record

[dpimental]

I have a "tabbed" form that originally was set to open on new record; but I have since changed that property.

But it still is opening on a new record, even though I am specifying ...

DoCmd.OpenForm "TabOrder",,,"orderno = 12"

David Pimental
(US, Oh)

 

[PHV]

What is the value of the DataEntry property of this form ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[dpimental]

The DataEntry Value is Yes.

Should it be no?

David Pimental
(US, Oh)

 

[PHV]

The DataEntry Value is Yes
So, only new record ...

 

[dpimental]

I changed it to no, here is what happened.

If I open it on its own, it starts on the first record, which is what I expect.

But, I am trying to oepn it from another form and it still is opening on a new record.

This form adds a new record, and I have a different form to edit additional information.

David Pimental
(US, Oh)

 

[bjb123]

Check the DoCmd.OpenForm line that opens that form.

perhaps that line includes acFromAdd, forcing it to open in DataEntry mode

 

[Remou]

Have you checked that OrderNo 12 exists?

 

[PHV]

I'd try this just before calling OpenForm:
DoCmd.RunCommand acCmdSaveRecord

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886