Multi-selecting records to pass to new subform

[jonchaz]

I am a new Access programmer and I have been creating a form that lists fees associated with person entered into my database.

I want to list multiple fees on the main form, and then have a new form open up on the click of the receipt button where only those fees that were selected (which allows for multiple selection) appear on the receipting form.

I am not certain how I can only pass those fees that were selected on the main form. If anyone could help, I would appreciate it, I know you have to do something with the selector, but I am at a loss.

Thanks,
John

 

[braindead2]

I suggest you look a a multi select listbox then base the new forms record source based on the items selected in the listbox. Several examples hve been posted on the multiselect listbox just do a keyword search

 

[jonchaz]

I have considered that, but the main form is a datasheet that has multiple fields. I guess I could try the list box, but I would like to know how to multiselect rows in a datasheet and than pas that recordset to the new form.

Thanks.