ListBox question

[rmd62163]

Is it possible to have the header of a list box show the value of another control?

[orange]

Can you describe an example of what you're trying to do?

[rmd62163]

I can do that.


The following code sets the row source of the list box and on the column c.LengthofAppointment as [30 minute slots] I would like to have the 30 portion of the header reflect the value of the control c.LengthofAppointment. If not, no biggy I can have the header say Length of Appointment. Don’t ask why Length of appointment isn’t sufficient, doing this for a friend. To each their own.

Me.Schedule.RowSource = "Select s.ID, s.ScheduleName as Name, s.day as [Date], t.apptstart as [Start Time], e.apptstart as [End Time], s.isreoccuring as Reoccuring, aw.NumPatientsPerSlot as [Patients Per Slot], c.LengthofAppointment as [30 minute slots] from schedule as s, appointmentwindow as aw , [time] as t, [time] as e, Clinic AS c where s.ClinicID = " & Me.ID & " and s.ID = aw.ScheduleID and aw.AppointmentWindowStartTime = t.id and aw.AppointmentWindowEndTime = e.id and s.ClinicID = c.id"