FilterOn property...unable to add new record when opening form with the filter on??

[RedGoneWILD]

Hi,



I have a form with the record source set to a query with a couple thousand records. There are two places to open this form in my program. One from the switchboard and it displays all records in the query. Another from a form that filters to meet a specific Employee Number. When I open the form from the switchboard (all records) the last row is a blank record. When I open with the filter on, the blank record does not exist. I have "Allow Additions" set to true, so what is causing this behavior?

I have a button on the form with the following code:

Private Sub btnAddNewRecord_Click()
    DoCmd.GoToRecord , , acNewRec  'goes to open record
    Me.cboDriverNumber.SetFocus      'sets focus to combo box
End Sub

It works fine when I open from the switchboard (with all records displayed from the query). It does not work and there is no blank record when I open it from the form with the filter applied.

Any suggestions?

[RedGoneWILD]

still cant figure this out...any ideas on this?