G
Guest
I have a form that uses a list box to select materials. There are four
columns with: Material Name, Young's Modulus, Poisson's Ratio, and Density.
The Material Name column is the primary key in the associated table.
What I would like to do is to select multiple materials from this list box.
The ControlSource for the list box is the associated material table, and the
list box is bound to the table.
When I change the multi-select property to simple, I can select multiple
materials, but they remain constant/fixed when I go to another form (acts as
if the list box is unbound). If I change the property to extended, I can
select several materials, but they do not remain selected (if I selected
multiple materials for form 5, then go to form 6 to fill it out, if I return
to form 5, the materials are no longer selected).
Can anyone point out what I am doing incorrectly?
Thank you
columns with: Material Name, Young's Modulus, Poisson's Ratio, and Density.
The Material Name column is the primary key in the associated table.
What I would like to do is to select multiple materials from this list box.
The ControlSource for the list box is the associated material table, and the
list box is bound to the table.
When I change the multi-select property to simple, I can select multiple
materials, but they remain constant/fixed when I go to another form (acts as
if the list box is unbound). If I change the property to extended, I can
select several materials, but they do not remain selected (if I selected
multiple materials for form 5, then go to form 6 to fill it out, if I return
to form 5, the materials are no longer selected).
Can anyone point out what I am doing incorrectly?
Thank you