Newbie Needing Help!

  • Thread starter Thread starter Jenny Z
  • Start date Start date
J

Jenny Z

I have worked on this for hours and am so frustrated.
Thank God for this Newsgroup! I am not that savvy with
access, but can manage to do a few things. I am currently
running Access 97. Here is my situation:

I have a form that has three subforms all linked together.
Believe it or not I managed to get them working
perfectly! One of my forms tracks new "student
registrations". Now there are a few different programs
that are running here, all collecting different
information, therefore I have 3 different registrations
forms geared to what program they are in. I would somehow
like to execute a d-click on the registration form and
open the appropriate registration form (according to
program). Each registration has a program number
entered. Can I somehow use that program number to
determine which registration form to open?

Thanks so much for your help!

Jenny
 
I have worked on this for hours and am so frustrated.
Thank God for this Newsgroup! I am not that savvy with
access, but can manage to do a few things. I am currently
running Access 97. Here is my situation:

I have a form that has three subforms all linked together.
Believe it or not I managed to get them working
perfectly! One of my forms tracks new "student
registrations". Now there are a few different programs
that are running here, all collecting different
information, therefore I have 3 different registrations
forms geared to what program they are in. I would somehow
like to execute a d-click on the registration form and
open the appropriate registration form (according to
program). Each registration has a program number
entered. Can I somehow use that program number to
determine which registration form to open?
Click to expand...

This could be done, but I'd suggest a simpler to implement solution:
put all three subforms on different pages of a Tab control and just
select the desired tab. You could do this manually, or you could have
the AfterUpdate event of the Program control (probably a combo box)
open the desired tab page.
 
Back
Top