How to link a Listbox and a Subform?

[mrmrmister]

Hello, I have a Listbox on a form that was made with fields from a Query. I have also created a subform on the same form page, which I would like to link the two, so that whatever records are selected on the Listbox are also shown in the subform.

The listbox is a multiselect listbox FYI. The reason why I would like to do this is because I am trying to extra certain fields from the Listbox to do other things such as a =Sum of one of the fields, however I know how to do this for a subform but not for a listbox.


Thanks guys! Please let me know if you need additional information!

[PhilOfWalton]

I may be wrong, but I don't think you can.
Assuming your subform is a continuous form (actually it doesn't matter if it isn't) you can only select one record at a time. It is easy to get to a single record from your list box, but, I can't see how selecting more than one item from a multiselect list box can work

Phil

[mrmrmister]

Hi phil, in the database I have, the form page I am creating is a 'Create Appointment' form, where the user creates an appointment for a client, and then assigns multiple or only 1 treatment per appointment.

In order to assign multiple Treatments to 1 AppointmentID, I created a table seperate from entities Treatment and Appointment, called TreatmentLog, which allows the user to assign multiple TreatmentID's to a AppointmentID, so that when viewing the Appointment, the subform shows multiple Treatments for that Appointment. (I know this is very very confusing).

I wanted the Listbox to be able to select the Treatments in a more user friendly way, and have the Subform hidden, but just have it hidden so I can do functions such as an =Sum for the duration or price, as I am familiar with how to do this for a subform but not for a list box.


If this is not possible that is no worries, but thank you for the resposne anyway Phil!.

[PhilOfWalton]

My approach would be to have a main form based on clients.
A continuous subform based on appointments (FrmSubAppts)
A second continuous subform based on Treatments. (FrmSubTreats)
As you select the current record in the (FrmSubAppts) this requeries the (FrmSubTreats) showing the treatments for that appointment.

Below is the sort of thing I use

The main form would be your client
The second form shows various pledges made by a donor (Appointments), and by clicking on a record, the third form shows the payments made (Treatments)

Hope this may give you some inspiration

Phil

[mrmrmister]

Thank you phil the information you have provided has helped me to do what I needed to do!