acCmdRecordGotoNew is not available at this time

[AdamOnAccess]

Hi Again,

I created a few forms that contain sub forms. To speed up the process of order entry, I designed a few sub routines that go to a new record in a sub form, or attempt to save a record in a sub form just before the focus shifts to something else. The code work most of the time but occasionally I get this error:

acCmdRecordGoTo New is not available at this time

Can someone explain the conditions that cause this error. I'm sure I can fix it if I understood more about what causes it.

Thanks,
Adam

[code green]

This is an MS Access question

[JeremyI]

I've just seen this happen in the process of attempting to do sort of the same thing (that's how I found your thread!).

Seems to be related to not having any records in the query that the subform links to, so I'm going to add an If statement to skip the acCmdRecordGoTo New step if that is the case.