A new record from an index form 1

[sagamw]

Hi guys!

I have an index form (that you search your record with a FAYT listbox) and I have a "New record" button in it.

My code for the click event is

DoCmd.OpenForm FormName:="MyForm"
DoCmd.GoToRecord , , acNewRec

It works (it opens My Form, and it ir ready to receive data) BUT for a split second I am seeing the first record and THEN the blank form.

How can I avoid this, and have myform open directly to the blank state?

 

[dhookom]

You could add a where condition that doesn't match any records or you could open the form in add mode.

Duane
Hook'D on Access
MS Access MVP

 

[sagamw]

Hi Duane and thank you for your answer.

I was ready to question you some more, But I found the correct syntax my self! {{phew!}}

Here's a star for your pointers!

 

[PHV]

For anyone finding this thread, here an oneline solution:
DoCmd.OpenForm "MyForm", , , , acFormAdd