Condensed List

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

Guest

I am trying to have one small page of information involving names and phone
numbers and then be able to click on a name which takes me to a place that
has more information on the individual I clicked on. Basically I am wanting
to have one big sheet with a whole lot of information but a smaller sheet
that has the same people on it just not all the information and then I want
to be able to click a name on the small sheet to where it takes me to the
information on the bigger sheet.
 
One possible solution is to create a subform of a single record view with "a
whole lot of information". Place this subform on an unbound form. Add a tall
list box on the same form. The list box can contain the names and phone
numbers (and invisible primary key value). Set the link master/child
properties of the subform control to the list box (Master) and the primary
key field name (Child).

When the user clicks a different item in the list box, the subform will
display the corresponding information in the subform.
 
I'd put a docmd..openform command into a doubleclick event on the
name. The form to open would be the smaller form that you want.
You'll need the Where clause (without the word Where) to identify the
record you want to show in the small form. You'll also want to
include the name of the current form in OpenArgs. All of that will be
done in one line. Then I'd close the current form.

In the other form you'd want a similar double-click on the person's
name with a docmd.openform(OpenArgs) and where clause to open the form
you just came from. Add another line to close the smaller form.
 
thanks for the help that worked just great.

Duane Hookom said:
One possible solution is to create a subform of a single record view with "a
whole lot of information". Place this subform on an unbound form. Add a tall
list box on the same form. The list box can contain the names and phone
numbers (and invisible primary key value). Set the link master/child
properties of the subform control to the list box (Master) and the primary
key field name (Child).

When the user clicks a different item in the list box, the subform will
display the corresponding information in the subform.
Click to expand...
 
Back
Top