Using VBA to Advance Form to Next Record in Acc2007 ?

[Gary]

I have a form with a Table as a recordscource. My code works in Acc2003, but
in Acc2007 it doesn't work.

I have the following RunCommand to advance the Form to the next record.

DoCmd.RunCommand acCmdRecordsGoToNext


In Acc 2007, I get the following error "The command or Action
'RecordsGoToNext'
isn't available now'

Can someone tell me what I need to do in Acc2007 to get my form to advance
to the next record ???

Thanks,

Gary

 

[tina]

i don't know about A2007, but in A2003 and prior, that message comes up when
the focus is already on a new record, or on the last record of a recordset
when adding a new record is not allowed (such as in a form with
AllowAdditions set to No, or in a form bound to a non-updateable recordset).
have you checked to make sure that isn't the case here?

hth