Unbound listbox in Continous Form

[Guest]

I have:

Form1 (Single)
Form2 (Single - Master/Child Form1)
Form3 (Continous - Master/Child Form2)
Form4 (Continous - Master/Child Form2)

I understand that I can't add a another continous form to Form4, but I would
like to add at least a listbox with data from another query which is linked
to Form4. Attempts to add an unbound listbox result in the same information
displayed on all the continous forms. Is there another way to accomplish this?

Many thanks!

 

[Albert D. Kallal]

Just use two sub-forms side by side...

Take a look at the following screen shot..especially the VERY last one:

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

note how we have a main record (top), and then on the left side...we have
"many" as continues sub form, and for each of those records, I display the
details on the right side

 

[Guest]

Just use two sub-forms side by side...

Take a look at the following screen shot..especially the VERY last one:

Many thanks for your reply, but the linking field can only be found in the
data which is contained in the continuous Form4. The information is similar
to telephone numbers, one record in Form4 can have 0-or-many entries and I
would like to like those entries to be always visible somehow next to the
correct record.

Is this possible?

Thanks!

 

[Albert D. Kallal]

Well, you could write a function that concatenates all the numbers (child
records) into one string value, and bind a text box to the function..

This would thus display a ',', between each value. however, you can't make
that box expand, or contract, so, it is not very clean.

There is a example of a function that concatenates the child records here;

http://www.mvps.org/access/modules/mdl0004.htm

So, there not much else then the above. Further, if the number of child
records is 3, 4 or 8..then how did you plan to have it expand? (So, placing
a listbox, or sub-from on the right side is about the only approach that can
display varying amount of data -- remember, each row in a continues form
cannot expand larger then its design size).