Dynamically change headers in listbox

[DavidCdp1]

Hi Everyone,

Can any one please tell me how to
pass parameters to a listbox based on
values selected from a combo box and input values in a text box.
The parameters should be passed to record source of the listbox.

Please Help.
DavidCdp1.

 

[Jon K]

In the After Update event of the combo box and text box, run code that builds a SQL statement based on the values of the combo box and text box, and passes the statement to the RowSource of the list box.

Dim SQL As String

SQL = "Select ...... " & Me.comboBox & "......" & Me.textBox & "....."

Me.listBox.RowSource = SQL

.

 

[DavidCdp1]

Thank You

Thank You very much John for your help.

DavidCdp1