Possible? List box on continuous form

[Buakaw]

Hi
Is it possible to use list boxes on a form with property "Default View" set to "Continuous Forms"?

The list box displays a list of choices the user can choose (taken from an SQL query).

Here's the problem. At one time, I can see multiple records on the form, along with multiple list boxes, one for each record.

However, the choices in ALL the list boxes that are displayed are the same as the record that has the focus currently.

E.g.
Record 1: What is your favourite colour?
List box choices: Blue, Red, Green, Yellow, Black, White, etc.

Record 2: Which month were you born in?
List box choices: Jan, Feb, Mar, Apr, etc.

However, in form view, when record 1 has focus, ALL the list boxes, even the list box for record 2, displays "Blue, Red, Green, Yellow..." etc.

When I click on record 2 and focus changes to record 2, all the list box choices on the form show "Jan, Feb, Mar, Apr" etc., even the list box for record 1.

Is there a way to actually to show the correct choices for each list box, if I want to use the form in continuous view?



Thanks!

[rpeare]

list box is probably not what you want to use for choosing items on data entry, try a combo box instead. List boxes are better used for selecting already existing items and manipulating them

[Buakaw]

Hi, I have to use a list box in this case because the user must be able to enter multiple answers for each question. I can't do that with combo boxes. Thanks.

[rpeare]

You actually can do it with combo boxes, but without seeing your data structure it's hard to give you direction.

Instead of a list box showing your sub table (I'm assuming you are doing this on a sub table and not trying to keep all your data on one table) you could have a sub form that's linked to the parent record and you could enter as many items as you want via a combo box.