General discussion

Locked

Access 97 Question

By mncurrr ·
I have two forms in an Access database for data entry. Each form has a record field that matches a record field in the other form. I want to be able to trigger the opening of the second form from a field on the first and go to the corresponding record. For example, if I am entering information on Company A in the first form, I want to automatically open the second form with Company A's information on that form.

This conversation is currently closed to new comments.

13 total posts (Page 1 of 2)   01 | 02   Next
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Access 97 Question

by Ravi In reply to Access 97 Question

You can put code in the "After Update" event properties for the field in question to open the second form: DoCmd.Openform "Form Name".

However, it seems to me that you need a form/subform kind of set-up, especially if there is a common field between the two forms and the data involved are in two different tables. I am afraid you haven't given enough details to comment further.

Collapse -

Access 97 Question

by mncurrr In reply to Access 97 Question

The question was auto-closed by TechRepublic

Collapse -

Access 97 Question

by MCSE Lee In reply to Access 97 Question

I agree with answer #1 - you should try to use Form/Subform. This also allows you to update the corresponding table(s) at the same time.

Collapse -

Access 97 Question

by mncurrr In reply to Access 97 Question

The question was auto-closed by TechRepublic

Collapse -

Access 97 Question

by r.m.stimpson In reply to Access 97 Question

Go to design veiw and incert a command button to open your second form and do the same on the second form to return to the frist form.

Collapse -

Access 97 Question

by mncurrr In reply to Access 97 Question

The question was auto-closed by TechRepublic

Collapse -

Access 97 Question

by Jan D In reply to Access 97 Question

You could make use of a new kind of form available in Access 97, the tabbed form, which makes it easy to switch from one form to another. You can put the first form on the first page, and the second on another tabbed form. The tabs can look like tabs or buttons. No programming is necessary. Alternatively, depending upon your key field linking ie linked fields (they must have the same name, be of the same data-type eg autonumber and long integer) you can do a form-subform arrangement. You can just drag and drop onto the form!

Collapse -

Access 97 Question

by mncurrr In reply to Access 97 Question

The question was auto-closed by TechRepublic

Collapse -

Access 97 Question

by nettech In reply to Access 97 Question

Without knowing exactly how you have your database designed, either of the first two answers will work very well for you- IF you have your relationships defined. I think that is the only thing I would add to the top answers. If you set your relationships, and you want no programming- then used the tabbed form, make your table A a main form and table b a subform. Then you can have both forms synced, updating at the sametime.

Collapse -

Access 97 Question

by mncurrr In reply to Access 97 Question

The question was auto-closed by TechRepublic

Back to Windows Forum
13 total posts (Page 1 of 2)   01 | 02   Next

Related Discussions

Related Forums