microsoft access

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

Guest

I am redesigning the database of the small nonprofit I work for. I would
like to have one form (linked, of course, to the appropriate table) with all
the members contact info. At the bottom of this form I want to have five
buttons with hyperlinks to other access forms. I think I have figured out
how to do all that. My question is, how do I send the contact's first and
last names to the hyperlinked form so that it appears on the top of the form?
Is this possible? Anyone have any suggestions?
 
Forms in Access are based on queries (or tables).

If you want Form2 to display a specific record (i.e., member), you need to
make sure that Form2 is based on that record. Or, if you are saying Form2
is NOT based on the member, but only needs to show the member's info, there
may be an easier way.

If you create a form that lets you pick a member and show that member's
info, you can add a tab control to the form to display the related sets of
information (?your 5 forms?). Add a subform to each tab page, and point the
subform to your form2, form3, ...

With a design like this, the main form info (member info) stays visible at
all times, and you can use the tab form to switch between related sets of
data. If you want to see an example of this design, open an Access database
in database view, click on Tools | Options and look at the tab setup.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top