Linking two forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there,

I have two forms FrmClient and frmSite. A client can have many sites.

I have created a sort of step sequence for users to add new client
information one screen at a time, clicking a 'Next' button to go to the next
step. I chose this route rather than using a subform becuase there is a lot
of information for each screen and a sub form did not look cosmetically
pleasing.

Nonetheless...my problem,

I want to be able to programatically link these screens together so that
data is saved and linked. That is...client header information is entered,
the Next button is clicked and the site information is entered. When the
user clicks Next, I want that information saved with the links in tact. This
is so whent the user goes back to review, the appropriate information for
each client (and their sites) are available.

Can you help me?

thanks in advance,
 
This can be done using two separate forms and a fair bit of coding.
Here's another option:
Put a TabControl on a form, with 2 tabs.
Copy/Paste all the controls from FrmClient onto the first page of the tab
control, and any code from that form into the new form's module.
Place FrmSite on the second page as a subform.
Now you have all the benefits of the main/subform organization, and all the
real estate of two forms.

HTH
 
Back
Top