Listboxes on continuous forms

[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

 

[Albert D. Kallal]

You can't use a listbox in a continues form.

however, what you can do is place a listbox (or another continues form) on
the same form...

Take a look the following screen shots;

http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

look at the very last screen shot. You can see the "many" on the left
side,..and for each "one" of those records, you can "many" on the right side