filter load

[slimjen]

All, using 2010; I have a data entry form. Recordsource is the table. I need the form to open ready for a new record but also only records for the current year. i.e. 2014. Right now I have this code when the form loads:

Private Sub Form_Load()
Me.filter= [yearadded]=2014
DoCmd.GoToRecord , , acNewRec
End Sub

Please help

[ranman256]

Me.FilterOn = True

[pbaldy]

Also it likely needs to be a string:

Me.filter= "[yearadded]=2014"

[slimjen]

Thanks for replying. I added the code suggested and got error "invalid use of property"

Private Sub Form_Load()
Me.FilterOn
Me.Filter = "[yearadded]=2014"
DoCmd.GoToRecord , , acNewRec
End Sub

[slimjen]

I corrected "me.filteron=true" and still does work but not error.

[pbaldy]

Try using what ranman gave you, and it would go after the line setting the filter, not before.

[slimjen]

Error: data type mismatch in expression??

Private Sub Form_Load()
Me.Filter = "[yearadded]=2014"
Me.FilterOn = True
DoCmd.GoToRecord , , acNewRec
End Sub

[pbaldy]

What is the data type of yearadded?

[slimjen]

Text. Inherited database. Will have to fix later but for now its text

[pbaldy]

Try

Me.Filter = "[yearadded]='2014'"

[slimjen]

That did it! Thanks bunches

[pbaldy]

No problem.