Change list box recordset

[dominicg123]

I would like to change a list box recordset used on my form. The record set will have to be base on a combo box. This combo box is filled with a list of field used in my table.

This is the code so far:

ListeClient.RowSource = "SELECT Clients.RéfContact,xxxx FROM Clients ;"

I want to replace xxxx with the value in the combo box but I am new to VBA.

Please help, Thank you

 

[Eupher]

Hi, dominicg123,

Something like this:

ListeClient.RowSource = "SELECT Clients.RéfContact, [red]'" & Me!MyCombo & "'[/red] FROM Clients ;"

...where [red]MyCombo[/red] is the name of your combobox. Note the single quotes - this assumes string data in your combo. If your combo is numeric, omit the single quotes; if it is a date/time, use # instead of single quotes.

HTH,

Ken S.

 

[PHV]

ListeClient.RowSource = "SELECT RéfContact, " & Me![yourCombo] & " FROM Clients"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dominicg123]

Thanks to both of you!