Form Name Problem

[jgelpi16]

I have a form named "frmNon-Corpofferinformation". However, every time I try to reference it in VBA it automatically changes the name to "frmNon - Corpofferinformation" (Note the spaces in between "frmNon - Corp...". When it does this it is treating "FrmNon" as a variable and telling me I don't have the variable defined. I am trying to obtain a value within that form and need to reference the form. This is the code I want to use:

varDenFrameValue = form_frmNon-Corpofferinformation.frameDenialOptions.Value

[pbaldy]

The inadvisable symbol in the name will always cause problems. I'd change it if it's not too late. If it is, try:

varDenFrameValue = Forms![frmNon-Corpofferinformation].frameDenialOptions.Value

[jgelpi16]

Unfortunately I was not the original developer and it would take way too much time to change everything. Thank you for the help.

[pbaldy]

No problem. I understand about being too far down the road to change the name. Get friendly with those brackets; you're going to need them!

[jgelpi16]

Thanks again! Will do!