I have a set of records, students needs statements, which are each
identified by a subject area. On a form, I have an unbound listbox with a
list of subjects. When I select a subject, the query selects just the
relevant records. I have a subform below the listbox which show the results
of the query. I would like these records to change when the listbox value
changes.
How can I get the subform to reflect the changes immediately, as soon as the
listbox is updated?

Many thanks,
Peter

You need to add some code in the after update event of the listbox to
"Requery" the subform.

    Me.subformControlName.Requery

Duane

| I have a set of records, students needs statements, which are each
| identified by a subject area. On a form, I have an unbound listbox with a
| list of subjects. When I select a subject, the query selects just the
| relevant records. I have a subform below the listbox which show the
results
| of the query. I would like these records to change when the listbox value
| changes.
| How can I get the subform to reflect the changes immediately, as soon as
the
| listbox is updated?
|
| Many thanks,
| Peter
|
|

On the listbox properties, go to Events tab, and for After Update, select [Event
Procedure] and use something like this:

Private Sub Listbox_AfterUpdate()

'after a change in the value of listbox, requery the subform
Me![name_of_subform].Requery

End Sub