Problems moving between subforms in a filtered form

[rbinder]

Greetings,

I have a form with three subforms. I have a filter in place to filter the data.

I do have to add records to the subforms. I can go to a new record by tabing to it, however I want to use some code so that if a new record is not needed then go to the next subform to further edit or add data.

The code I am using to go to a new record is;
DoCmd.GoToRecord , , acNewRec
or the next subform
DoCmd.GoToControl "Frmdestination"

the error I get is 'can't go to the specifided records

I have set the form controls;
allow edits
allow deletions
allow additions to yes and no
Data Entry to yes and no

All do not allow me to go to specific records through code?

I have played with this for a long time to get it right and getting frustrated.

~rbinder