List boxes and dependent fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box where a user can select multiple values. For each of the
values then selelected I need to store a number (total) for each value
selected in a table.

Since I don't know ahead of time how many values can be selected I had
thought of some sort of dynamic form generation that would generate the
number of text boxes that I needed for data entry but this doen't seem to be
s supported method in access. Is there another way of doing this?

thanks
Mike
 
Mike,

You could have been a little clearer. Do you mean the selections in the
listbox correspond to records already existing in a table, in which you
wish to fill in a field? Or what?
If it's something like that, the answer is simply a continuous form. Be
as specific as you can (include table, field, form and listbox names)
and you'll likely get some good suggestions including sample code.

Nikos
 
Back
Top