Using Subforms

[Guest]

Ok, i have a book and i have a basic understanding of how to use subforms.

However, what i've learned only allows me to edit related information at once.

What i really want is to have a nonupdatable form that only allows you to
look up or view information.

For example.
the Main form would have a list (combobox) of all the centers or departments
in the company
The subform would display a list of all the names in that department (maybe
in a datasheet) and columns of related info.

In the examples in my book, if you change the item in the combo box it
updates the new information. However, i want the combox to be used to
display information. When the center or department changes, i want the
subform info to change to suit the new center.

Can this be done? Thanks!

 

[manningfan]

If there are just textboxes on your subform, can't you just set their
"Enabled" property to "No"? This will make it so they can't be
enabled.

 

[Guest]

I don't understand how that is relevant to my question.

My question is what is the difference between a form that allows you to look
and one that allows you to update. i'm familar with preventing people from
changing values, but that's not my question. When the combo value is
changed, i want the subform info to change as well.

In an updatable form, changing the combo box only changes the value not the
information that displays in the subform.

Thanks!

 

[Guest]

Guys, i don't really think what i'm asking is hard to understand.

Rather than using the recordset arrow at the bottom to move through the
recordset, I want a combo box that will allow me to list out all the
departments. By choosing a department, all the employees in that department
and related info is displayed in a subform.

Thanks. I would assume this is relatively easy to do. I just don't know how
to do it because my examples in the book only use updatable forms.

Thank!

 

[John Vinson]

In the examples in my book, if you change the item in the combo box it
updates the new information. However, i want the combox to be used to
display information. When the center or department changes, i want the
subform info to change to suit the new center.

Change the Master Link Field property of the subform to the name of
the combo box (the combo's bound column should be the appropriate
DepartmentID field).

John W. Vinson[MVP]