Opening a form in different ways

A

Amit

Hi,

I'll appreciate any help on this.

I have a form to enter Person information for an
Organization. This has the Organization ID as a foreign
key, and designed as a combo-box to select the
Organization Name (and ID).

I also have a form to enter Organization information. I
would like to design a button at the bottom to enter
Person information (if available at that time) which will
bring up the first form (Person form), and have the
Organization ID automatically be selected from the
Organization form.

How do I code these two different instances? Can I use the
same Person form for both? If yes, then how? I'm not an
expert in VBA, but can this be accomplished by adding some
code in the "afterclick" property of the button to open
the Person form, and have the organization ID in it be
assigned to the organization ID from the original form?
(this is just an idea - not sure if it is feasible...)

This is to cover the following instances:
1. Organization info has been entered earlier, new Person
for that Organization needs to be added (Person form).
2. New Organization information needs to be added, along
with new Person info for that same organization
(Organization Form, then use button to open Person Form).

Thanks in advance.

-Amit
 

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