MORE HELP needed for Main Form/Subforms

  • Thread starter Thread starter Jacqueline
  • Start date Start date
J

Jacqueline

Access 2000 frontend...linked to tables through SQL
Server 7.0 backend...I posted below and both of these
questions are related to the same form...

My main form gives me UserName and Email from User
table...UserID is common field in all tables.

I have 8 command buttons that run along the lefthand side
of this main form that I want to have open subforms
related to the UserID given above....ie: MCAT,
References, Academic Information, EmploymentHistory,
etc...
To the right of each of these buttons are
checkboxes...that collect data from the CompletedSections
table when those sections are completed by the applicant
on the web application form.

There are a lot of fields on these forms...so there
wouldn't be enough room to have them show as subforms to
the right of the buttons and checkboxes.

How else can I have them open but have it only show the
info related to the Applicant name on this main form?

How can I make these
 
Jacqueline,

Modify the code that is opening the forms to use the WHERE
clause of the OpenForm line to filter the forms record to
the ID on your form...

DoCmd.OpenForm "frmReferences",,, "[UserID] = " & Me![UserID

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________
 
Back
Top