list box update problem on continuos form

[Shaft]

I have a list box on a continous form that dynamically pulls it's information by why of a query where a field in the query is equal to the value of a field on the form.

The problem is it only does it for the first record and every record after that has values based on the first record. Is it possible for the list box to show different values for each record or is there an alternative method of pulling the information.

 

[MarkK]

Note that a continous form only has controls for ONE record, but also displays multiple records. When you set properties of one control, these settings are applied to that control for ALL records.
Chances are slim that you can use a listbox to good effect on a continuous form. Use a continuous form to show the many items related to one item. If each one of these many items are related to many other items, you probably need another form.

 

[godofhell]

You should change to a Master form subform layout.

 

[Shaft]

You can't use a subform on a continous form though and for the purpose of this exercise I need a continous form. As I need to show all the results on one page.