List box on subform (beginner)

List box on subform (beginner)

Post by Angus Cros » Sat, 23 Aug 2003 00:40:42

I have a list box on a subform. I expected that when I move from record to
record on the main form, the listed items would change on the subform
appropriately. However the displayed list always remains the same,
regardless of which record is displayed on the main form.
The list box is unbound, and is populated using a SELECT statement in its
datasource property. I suspect that I have the syntax of the latter wrong,
but can't get my head round it. Can someone give me some pointers please?

List box on subform (beginner)

Post by M Skabialk » Sat, 23 Aug 2003 00:59:46

Have an invisible field on your form so that when a selection is made from
your list, it updates the value in the new field.

Then link the sub-form to the value in that field.




List box on subform (beginner)

Post by Angus Cros » Mon, 25 Aug 2003 01:11:04

Thanks Mich, I did that and its working nicely.