Multiple adds at once......Suggestions?

[alaric]

Hi
Im trying to make an app for dancinglessons and I cant figure out a nice way to give the user:
a form that shows all the users vary between 1 and 20 (based on a query) and can add 8 different scores to all names.

I have thought of a continueos form, but (as far as I know) this is limited to add scores to only one user at a time.

So is it possible to design a form that allows multiple adds in one time??

I have been thinking and trying now for more than a week and still have nothing usable

please .. any suggestions crearive ideas are more than welcome
Everlasting remembrance will be my reward

Al

 

[Pat Hartman]

See if this Multi-Select Listbox example gives you some ideas. We use it to take attendance at our monthly Access users group meetings.

 

[alaric]

Thanks Wayne

I designed already something similar. But I have some trouble with my listbox

I have 2 lisboxes. the first one I use as a filter for the second one. In the fist listbox I want the user to selct max 2 items. The user gets a message when he selects the 3th.. so far so good.
Now my 2nd listbox pushes (dblclick) values from the listbox to textboxes
I managed to do this with a single value. But Im struggeling with doing this for about 12 values.
each value should go into a different (free) textbox (next available)


any hints for me?
I really appriciate your help. When I started this I was really a newbee with VBA (only some ancient basic knowledge). This forum helped me great. The program Im trying to make is for a friend wich Im making for free to help him.

greetz
Al