Error only on first record.

[mafhobb]

I have a small database with several forms. One of them has a command button to open a new form (which also contains a continuous subform) and go to a new record in the form. This is the code behind it:

    stDocName = "Main Data Entry"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    DoCmd.RunCommand acCmdRecordsGoToNew

This database has been in use for quite without problems a while but now I am doing a few small changes and cleaning it up of data to start over.

The code above gives the error "The command or action "RecordsGoToNew" isn't available now" yet it opens the form just fine and data can be entered. This error only happens when the first record is entered; it does not show up when entering the second or subsequent records.

Anyone know what is happening?

mafhobb

 

[sensetech]

Maybe it's already in "new record" mode because the underlying table has no existing records?

 

[mafhobb]

It seems like Access should know how to deal with that???

How can I know for sure that this is the case?

 

[sensetech]

I've often found that other DoCmd's relating to record operations aren't always as clever as you'd like them to be.

There must be a VBA-checkable property that would tell you that the form / underlying recordset is in "new record mode" but I don't know what it is off the top of my head.

 

[mafhobb]

Well, it seems like a cheese way to solve it but I basically captured the error number and told the code to ignore it. Not an elegant way to solve this but it works.

mafhobb

 

[sensetech]

A fine contender for the January "Golden Spur" award. I would never have suggested that myself, of course

 

[David R]

There must be a VBA-checkable property that would tell you that the form / underlying recordset is in "new record mode" but I don't know what it is off the top of my head.

If(Me.DataEntry = True)

, I believe.

Although I think if I understand the question correctly, the form is already in DataEntry mode and you want to check if this is already a new record. Me.NewRecord will get you that.

 

[mafhobb]

The form is not set for Data Entry mode. It is a form showing a record that can be edited or can be used to add a new record.

 

[David R]

Something else must be going on to stop it from moving records, then. Have you tried:

Docmd.GoToRecord acDataForm,stDocName,acNewRec