How to edit where a form is pulled from within a table

G

Guest

I have created a database for various information at work. I need to change
which form is pulled up when I click the button within another form. In other
words I want to replace one form(questionnaire) for another but don't know
how to change where it is puuling it from to do so. I don't know a lot about
access but I am pretty computer savy. Any help would be appreciated.
 
G

Guest

Open the form with the button that opens the form you want to replace in
design view. Select the command button that opens the report. Select
properties either from the toolbar or by right clicking and selecting
Properties. Click on the events tab. In the text boxk for On Click you will
probably see [Event Procedure]. There will be a small command button just to
the right with three dots ...
Click on that button, and the code that executes when the button is clicked
will come up in the VB editor. There will be a line that opens the form and
it will have the name of the form in qoutes. Change the name to the form you
want to open, close the VB editor, save the form, and give it a try. Your
new form should now come up.

Be sure you have a back up copy of your mdb before you make any changes.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top