A
a.t.brooks
Me again! Promise not to monopolise all of your time.
Does anyone know how to get listboxes working on continuous forms?
I have a continuous form. On each record there is a primary key, PK. I
want a listbox showing ITEM on each record based on a query using the
primary key as a parameter. I have built a simple query with
[Forms]![MyForm]![PK]
in the criteria of the Primary Key field and another field with the
ITEM in it. When I create a listbox containing the ITEM field of the
query, I get the same results for every listbox. Setting the listbox
from unbound to bound to the primary key allows me to click between
records and get all the listboxes to update to the results from
whatever record I'm on, but I'd ideally like different values in the
listboxes on each record.
Thanks in advance
Tony
Does anyone know how to get listboxes working on continuous forms?
I have a continuous form. On each record there is a primary key, PK. I
want a listbox showing ITEM on each record based on a query using the
primary key as a parameter. I have built a simple query with
[Forms]![MyForm]![PK]
in the criteria of the Primary Key field and another field with the
ITEM in it. When I create a listbox containing the ITEM field of the
query, I get the same results for every listbox. Setting the listbox
from unbound to bound to the primary key allows me to click between
records and get all the listboxes to update to the results from
whatever record I'm on, but I'd ideally like different values in the
listboxes on each record.
Thanks in advance
Tony