Simple VBA question-> syntax

[fmcampos]

I think this is a fairly simple problem. I have to make a reference in a procedure to a form that has "spaces" on it´s name. I have done this in the past when referencing to a field just by changing the spaces to "_". But that doesn´t seem to work when referencing to a form. I know i should have created everything without spaces, but it´s gonna be such a hassle to change everything back now...!

ex:
the form name is [bla bla bla]

form.bla bla bla.value --> doesn´t work
form.bla_bla_bla.value --> doesn´t either

tkx

fmc

 

[Dugantrain]

If you're referencing the form from a Form Module, then you can use the 'Me' Keyword in place of the actual name. If you're referencing the form from a Standard Module, then the reference should be:

Forms![bla bla bla].Value

Note that there is actually no 'Value' property of a form, so unless you're just using the word 'value' to mean some generic form Property, Method, or Event, you're still going to get an error.