Continuous SubForm ListBox 1

[hedidit]

Hi all,

I have a form with a subform. The subform lists all records associated with the main form.

The continuous subform has a list box that lists records from a table based upon a value in each subform record BUT the content of the list box isn't updating for each subform record... usually i'd look into using requery on the onload event but think this is for reports only?

Can anyone help me out with this?

Cheers in advance?

 

[hedidit]

actually i just found a previous post i made that you replied to but that, for some reason, doesn't work?

I tried putting:

[a].Form!Combo6.Requery

Where [a] is the subform of my main form and combo6 is the list box name. I've put this code in the afterupdate event of the main form... any ideas? Thanks for your help

 

[TheAceMan1]

hedidit . . .

Sorry to get back so late . . .

[purple]A listbox in the detail section is a bad idea![/purple] Realize its a [blue]single listbox object[/blue] and can't display a seperate RowSource for each record. So when you update the listbox they'll all show the the results of the same RowSource!.

You need to move the listbox to forms header or footer section. then try the code again . . .

See Ya! . . . . . .