Go to New record in subform (1 Viewer)

[jzacharias]

Can't seem to find an answer to this. I want my sub form to always go to a new record when I navigate through the main form's records. I am able to go to a new record with the open event and a macro, but it's a one time event.

 

[MStef]

Look at "DemoSubNRecordA2000.mdb" (attachment, zip).
Open frmMAIN and see.
Put it "ON CURRENT" event (instead "ON LOAD").
Look at VBA.

 

[jzacharias]

It still didn't go to a new record as I navigate through the main form's records

 

[MStef]

Did you put the code in "SUB FORM_CURRENT", (instead of "Sub Form_ Load"), in subform ??
Look at attachment, Access help (word, zip).

 

[rodmc]

Wouldnt it be easier to set the subform to "data entry"?