Can't go to specified record

[Bryce]

I have a form with a tabbed subforms. My problem is the Add button. It gives me an error message, 'Can't go to specified record'. The VBA code running is:

DoCmd.GoToRecord , , acNewRec

I can add a new record if I use the Navigation bar or GoTo on the Menu bar, but my code will create an error. I want to turn off the navigation bar to avoid users from seeing all records. I have a dropdown list which allows the user to only see those records permitted. How do I get my Add button to work again?

The form is linked to a table so all fields are bound. Any help is appreciated.

[RuralGuy]

Is the Button on the MainForm or the SubForm?

[pkstormy]

If your trying to add your add button to the main form, you want to instead add your add button to the subform. Then your docmd.gotorecord.... will work.

[Bryce]

Thanks for the responses. Let me clarify my predicament a bit further.

My Add button is located on the main form, which is what I want. The subform use their Navigation buttons to add records. The Add button worked before, then I filtered or locked records based on the User's setting and I set the Navigation bar to 'off', so the user would not be able to scroll through records. The user must use a combo box to open a record (which is filtered). If they want to add a new record, then of course they use the Add button. The combo box should not impact the Add button coding.

What gets me is that I can get a blank record if I use the main form's Navigation bar's button or the Menu 'GoTo' combo box. I tried other commands with similar results (i.e., DoMenuItem and RunCommand)

Now the Add button gives me the "Can't go the specified record" message. I'm not sure if I'm overlooking another property setting that I may need to set?

Thanks again

[Bryce]

I took out some message box code, confirming the Add action, and it works now. Not sure how that created the error message before, but I'm fine with it. So I solved the problem myself. Thanks again for your responses.

[RuralGuy]

The important thing is the problem is fixed! Thanks for posting back with your success.