List box on subform (beginner)

  • Thread starter Thread starter Angus Crossley
  • Start date Start date
A

Angus Crossley

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?
 
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.

Mich
 
Thanks Mich, I did that and its working nicely.

M Skabialka said:
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.

Mich
Click to expand...
 
Back
Top