Solved Way to avoid form flashing when load full records and goto newrecord?

[Babycat]

Hi Everyone

My table TBLPRODUCT have a number of records.
I want to addnew record but it requires to open form FrmProduct with full records from table.
So I tried with code:

DoCmd.OpenForm "FrmProduct"
DoCmd.GoToRecord acDataForm, "FrmProduct", acNewRec

You can imagine it requires two steps: Open and display first record, then go to new record. This makes form flashing.

I dont want to use

DoCmd.OpenForm "FrmProduct", , , , acFormAdd

becasue it does not load other existing records into form.

I have tried DoCmd.Echo false (then true) but it did not work.

May anyone help to advise a solution?

Thank you!

 

[arnelgp]

you can remove the second code, when you use the Form's
Load event to GoTo newrecord.

 

[Babycat]

you can remove the second code, when you use the Form's
Load event to GoTo newrecord.

Thank Arnelgp

I also have other button to open the form FrmProduct not in newrecord mode.
Thus, how to differentiate them? Should I make a global varibale so that Load event can perform according.
My bad habit is always try to minimize number of global variable unless it must...

 

[arnelgp]

you can pass an OpenArgs when you open your form:

DoCmd.OpenForm FormName:="yourForm", OpenArgs:="New"

now on the Load Event of "yourForm"

Private Sub Form_Load()
If Me.OpenArgs & "" = "New" Then
DoCmd.GoToRecord,,acNewRec
End If

 

[Babycat]

you can pass an OpenArgs when you open your form:

DoCmd.OpenForm FormName:="yourForm", OpenArgs:="New"

now on the Load Event of "yourForm"

Private Sub Form_Load()
If Me.OpenArgs & "" = "New" Then
DoCmd.GoToRecord,,acNewRec
End If

Oh, now I understand about OpenArgs, I have never known and used it.
A great learning for today.

Much appreciated your helps.