How to add a button to a form that opens another form

[Kim]

Hi all,

I'm using Access 2002 and am having trouble creating a button to open
another form.

I've done a bit of research but am just starting out with all this so
am having trouble.

Can someone advise me in basic terms how to do this?

Thanks.

Kim

 

[Bob Quintal]

Hi all,

I'm using Access 2002 and am having trouble creating a button to open
another form.

I've done a bit of research but am just starting out with all this so
am having trouble.

Can someone advise me in basic terms how to do this?

Thanks.

Kim

In design view for the form, make sure to enable the wizard on the
toolbbox, then drag a command button from the bar to the form. Select
form operations from the wizard, select open form from the options then
select your target form. You can choose to open the form to a specific
record, or all records..

 

[Kim]

In design view for the form, make sure to enable the wizard on the
toolbbox, then drag a command button from the bar to the form. Select
form operations from the wizard, select open form from the options then
select your target form. You can choose to open the form to a specific
record, or all records..

Thanks so much Bob.

Worked perfectly. )

 

[Kim]

In design view for the form, make sure to enable the wizard on the
toolbbox, then drag a command button from the bar to the form. Select
form operations from the wizard, select open form from the options then
select your target form. You can choose to open the form to a specific
record, or all records..

Oops... all the steps seemed to work but when I press the button while
it's running I get the message "The expression On Click you entered as
the event property setting produced the following error: Object or
class does not support the set of events.

Any advice on how to fix this?

Thanks again!!!

 

[John W. Vinson]

Oops... all the steps seemed to work but when I press the button while
it's running I get the message "The expression On Click you entered as
the event property setting produced the following error: Object or
class does not support the set of events.

Any advice on how to fix this?

Thanks again!!!

Please open the form in design view; select the button; click the ... icon by
its Click event; open the code window and copy and paste the code to a message
here. Also post the Name property of the form that you're trying to open.

One suggestion: don't use blanks, punctuation, or special characters
(particularly parentheses, apostrophes and quotes) in the names of objects. If
you're doing so try changing the name of the form to contain only letters,
numbers and underscores and see if it works better.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Kim]

Please open the form in design view; select the button; click the ... icon by
its Click event; open the code window and copy and paste the code to a message
here. Also post the Name property of the form that you're trying to open.

One suggestion: don't use blanks, punctuation, or special characters
(particularly parentheses, apostrophes and quotes) in the names of objects. If
you're doing so try changing the name of the form to contain only letters,
numbers and underscores and see if it works better.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

Every time I go into "view code" my access crashes. I think I need to
reinstall first.

 

[John W. Vinson]

Every time I go into "view code" my access crashes. I think I need to
reinstall first.

That's not going to help, I fear. I don't think it's the Access executable
that's corrupt; it's probably your database.

Try Tools... Database Utilities... Compact and Repair (after making a backup).

If that doesn't work try the suggestions at
http://www.granite.ab.ca/access/corruptmdbs.htm
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[SadiaWillMosh]

Figured this out by myself . Dunno about 2002 version because im using 2010 . But the easiest way I've found is to insert a button on your form and right click it and go onto build event and then choose MACRO BUILDER. Macros are literally so easy. its so self explanatory to use. Just select "openform" from the top drop down and then which form you want to open on the second drop down. Hit save on the top and viola. You can then test it out on form view. Congrats x