ACCESS FEED: RE: [MS_AccessPros] Correct syntax for form name

Senin, 12 September 2011

RE: [MS_AccessPros] Correct syntax for form name

Are you sure the form is open when this code runs? Are you certain the
form's actual name is "Change Password"? As you have probably heard before,
spaces in object names (along with special characters) tend to cause more
problems than they are worth in "readability". It's almost always a better
strategy to avoid that whole issue by adopting a naming convention which
avoids them. I.e. Why not call this "ChangePassword"?

HTH

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Art
Sent: Monday, September 12, 2011 10:08 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Correct syntax for form name

I am trying to reference a form called Change Password in the following
code:

Select Case intResponse
Case vbYes
DoCmd.Quit
Case Else
Forms![Change Password].Visible = True
End Select

But it errors that it can;t find Change Password form.

I tried Change_Password but that didn't work either.

Any ideas?

Art Lorenzini
Siou Falls, SD

[Non-text portions of this message have been removed]