Is this possible in Access

A

Ayo

I am trying to do something that I am not sure if it is possible or not. I
have 2 forms. I want to click on a button on form1 to go to form2. Form1 is
the data form, the one use to enter records into the database. Form2 is just
a summary form that summarizes the data on the first form.
What I want to be able to do is, when I go to form2, I want to click on one
of the buttons on form2 to take me back to the exact record I was on when I
was on form 1. For example:
i, on form1 record 10, say,
ii, click a button on form1 to go to form2
iii, finish on form2
iv, click a button on form2
v, go back to form1 record 10

This is all I want to do. Is this possible?
 
W

Wayne-I-M

Hi

Yes it all possible - but I think (just my opinon) you may be over
complecating things before you have even started.

One form one create a button (or other event) to open form two as a
maximised popup. Put a close button on form two somewhere and this will do
everything you want.

Of course you could refine this by putting criteria on the OnClick of the
button on form one to limit form two's conent, etc,etc.

I would keep it very simply at first to get it working and then refine it -
if needed
 
R

roccogrand

Yes. You can use the Command Button Wizard to place buttons on the forms.

Turn on Design View with Form 1 selected.

Draw the Command Button on the form.

In the Wizard, select Form Operations and then select Open Form.
Click Next.

Select Form 2
Click Next.

Click Open the form and find specific data to display.

Select the matching field in the two forms.

Click Next.
Name the button or use a picture for it.

Click Finish and return to Form View.

It may not be necessary for you to click Open the form and find specific
data to display -- but this forces the records to be the same.

Now follow the same steps on Form 2, setting the Open Form command this time
to Form 1.

HTH

LDN
 

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