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?