Naming Forms

[buckwheat]

An inherited database has several forms named such as: frmAdd New Facility - subform.



I'm trying to create a form that opens with no subforms showing and subforms executing when a cmdbutton is clicked. Code I've used in the past for an Open Event: Me.frmSample.visible = false. Then on the cmdbutton for the frmsample: Me.frmSample.Visible = true

What should I do about the poor naming convention for these forms if I want to use the code above? Too many reports, queries, and macros attached to rename.


Can anyone advise please?

[pbaldy]

Put brackets around the names, just like fields.

[buckwheat]

how so please . . . I tried before thread, if it's this format I receive a an error that field l cannot be found. Me.[frmAdd New Facility].visible = true

[buckwheat]

ok, now fixed, it appeared in the drop down list with spaces, but still worked. Thanks for your help.

[pbaldy]

No problem.