Access: the code contains a syntax error

Question

When I try and place a command button on a form I get the following message:

Answer 1

Hi Dennis, I'm an independent adviser and will try to help.

But I need help from you to do so. The error message you are getting indicates there is a syntax error in your coding. But to spot the error, we need to see the code. So please respond with the code behind your button. It would also help if you could step through the code and find the line that throws the error. You can try doing a Debug of the code and see if it highlights the offending line.

Please help us help you.

Answer 2

There is no code behind the button (that I can find). 

This happens when I select a command button and place it on the form (In design mode). I believe that a command wizard should pop up, but I only get the pop up that I attached.

Answer 3

This makes little sense. You can't have a syntax error if there is no code. I would open the VBE (press Ctrl+G) ad then open the Debug menu and press Compile to find all syntax errors. I would also try a Compact and Repair.

Answer 4

I will try what you ask, but I want to emphasize that the pop up happens when i place the button on the design space. I have watched a video that indicates that a wizard is supposed to be activated to help in the design of the button function. That does not happen. Can the wizard have a syntax error? I'll let you know the success of what you asked me to do. I am a novice in Access and Visual Basic.

Answer 5

I ran the compile menu item and the following error came up:

AcCmdRecordsGoToNew

Compile error

Invalid use of property