Hi there

Another easy question for you advanced users

I'd like to put in a few commands on the 'On Open' event of my form. Firstly to maximise the view, and then to sort my records in the 'venue' field alphabetically. I have a query saved that does this, which I've called 'qfltVenueAlpha'

This is what I have so far that works:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub


I can't however seem to get the DoCmd.ApplyFilter to work - am I barking up the wrong tree?!

Thanks

Oh dear! I just realised this should be set as part of my criteria in the record Source's query - doh!