Use command button to open a form from within another form

[Guest]

I'm trying to use the command button wizard to open a form from within
another form. I'm not a VBA programmer. I just get an error. Both forms
work on their own. How do I make this work? THANKS!

 

[Jeff Boyce]

Open Form1 in design view.

Use the Toolbar. Make sure the 'wizards' are turned on.

Select the command button tool. When you place your new command button on
Form1, Access will prompt you to indicate what you want to have happen when
the button is clicked. Pick the Form-related choices, pick the
open-form-related choice, fill in the name of the form you want opened.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Thanks - but this is exactly what I did. I also made the form associated
with the command button a pop-up form. This is the error I get: "THe
expression On Click you entered as the event property setting produced the
following error: A problem occurred while MS Access was communicating with
the OLE server or ActiveX control."
Could this have something to do with the fact that this mdb file was made as
a copy of another mdb file? One other thing I can't do with this file is
build an mde file from it. Is there a way to make it not a "copy" - a way to
make Access think its an original mdb file? This may have nothing to do with
the error - just grasping at straws here...

 

[Guest]

Well - I made a new mdb file and imported all the stuff from my old mdb file
and now it all works. Thanks for your time!!