Microsoft Access Can't Find the Macro '.' 1

[victory92]

I am getting this error when I try to enter a value in the second field in a subform. I don't have a macro. Looks like there is a period somewhere that Access is intrepreting as a macro. But I have no idea where it is. I've looked at the code. Any ideas?

Here's the full message:

The macro (or its macro group) doesn't exist, or the macro is new but hasn't been saved. Note that when you entere the macrogroupname, macroname syntax in an argument, you must specify the name the macro's macrogroup was last saved under.

I'm new to Access and subforms and would appreciate any detailed answered you may give. Thank you.

 

[GKProgrammer]

You are going to have to post the code in order to get the help that you require. Regards,
gkprogrammer

 

[victory92]

Here's the code for the subform. It's very basic - only 2 statements under the form load event.

Can you shed some light on what would cause this message? Thanks

Option Compare Database

'==========================================================
Private Sub Form_Load()
'==========================================================
Commission_Month = CommMO
Commission_Year = CommYR

End Sub

 

[victory92]

I found the problem. I was able to find it at Microsoft.com
Unfortunately, the error description is not very good.

For anyone whose interested - here is the cause and resolution:

CAUSE
This behavior can occur if you inadvertently type one or more spaces in the event properties of either a form or a control, such as in the OnCurrent or the AfterUpdate property.

RESOLUTION
Open the form in Design view and remove the space(s).