Hello,

I am a newbie in VBA, so I'll try to explain my problem :

I have to modify an application which is written in VBA (Access).
There is a form with displays several rows of data obtained from a SQL
Server database.

For that purpose, the form is made of three parts (header, footer, and
the middle part). The middle part shows only one row of controls in
"Creation mode" , but it replicates itself several times when the app
is running, so it can show up to 8 lines of data. It's obviously a
"dynamic" form.

I tried to add one control (a listbox) in "Creation mode" at the end of
the row. When the application is running, I get a listbox at the end of
each 8 rows, but when I try to to select a value in one of the
listboxes, all the listboxes of the form select the same value !

What I really need is that all 8 listboxes are independent from each
other, and that different values can be selected in each of them with
no interference with the others.
Is there some property I need to set to make the listboxes independent
?

I hope my description will make sense, and you'll help me to find a
solution.

Thank you very much for any hint or help !

--
Bleu adj, et n. m. : Qui est d'une couleur voisine du rouge. Fig
Bouch. : un steak bleu ; s'emploie pour designer un steak rouge. Fig.
Mil. : un nouveau : "Faut pas me prendre pour un bleu" (Rackham le
Rouge).

Archived from group: microsoft>public>vb>syntax