Open form go to new record

[cardgunner]

I just upgraded to Access 2007. When in 2003 I would open a form and it would go the a new record but the form was not filtered. Now when I open the form it filters it.

my Open event procedure is

Private Sub Form_Open(Cancel As Integer)

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_call_log_table"
DoCmd.OpenForm stDocName, acFormDS, , stLinkCriteria
DoCmd.GoToRecord , , acNewRec

End Sub

What do I need to do so when the form opens it goes to the new record but does not filter it?

 

[boblarson]

One, why are you including stLinkCriteria when there's no criteria? That makes no sense.

 

[cardgunner]

That is what the command button wizard set. I went in after that and added the command to go to the new record.

 

[boblarson]

That is what the command button wizard set. I went in after that and added the command to go to the new record.

Try pulling it out and see if that helps at all. Also, the form doesn't have its DATA ENTRY property set to YES, does it?

 

[cardgunner]

The data entry is set to no.

when I take out stLinkCriteria and leave that line like
DoCmd.OpenForm stDocName, acFormDS, ,
I get a compile error Syntax Error

 

[boblarson]

The data entry is set to no.

when I take out stLinkCriteria and leave that line like
DoCmd.OpenForm stDocName, acFormDS, ,
I get a compile error Syntax Error

When you have no parameters in there you don't leave the commas after the last item. So remove the last two commas to make it:

DoCmd.OpenForm stDocName, acFormDS

 

[cardgunner]

I did that as well and got the same error.

I appreciate your help Bob but I had a saved filter and I went in somehow and deleted the filter or something but it works now. This is the issue with upgrades...you never know where the heck things are.

Thanks again.

 

[vbaInet]

And this one line will open the form and create a new record:

DoCmd.OpenForm stDocName, acFormDS, , ,acFormAdd