GotoRecord New after filter

[g]

Hello experts,

This is what i've used for my subform to interact with my treeview control
on the Main Form of my database.

Forms!FormMain.FormSub.SourceObject = "Form1"
Forms!FormMain.FormSub.Form.Filter = "SPP = Forms!FormMain.USite"
Forms!FormMain.FormSub.Form.FilterOn = True

And it works perfectly fine. Now I need to know how to do to make it open
(The subform) always in a new record. As of now it always open on the first
record with filtered note at the record navigator.

I tried to add DoCmd.GotoRecord , , acNewRec after my code above but it
didn't
work. Also tried to put it in on open, active, load on the Form1 event to
experiment
but it didn't work as well.

Thank you in advance

 

[Maurice]

Easiest way is to put the form in dataentry mode that way you will always go
to a new record...

hth

 

[g]

Are you referring to the form property Data Entry set to yes coz that didn't
work.
Any other suggestion?

Thank you