Fill ListBox with Recordset Field 1

[perrymans]

I have two listboxes, one has the saved 'Filters', the other I want to list one field from that first filter.

So lstFilter.Column(2) is:
"SELECT * FROM SelQ_MemberEmail_Filter WHERE (((DroppedDate) Is Null))"

And AfterUpdate I can set lstResult.Rowsource to equal that column, but the filter may have any number of fields, in any order.

I am only interested in the field called 'Email'.

So I want to fill the listbox with the field Email from the filter selected in lstFilter (all have the email field in them somewhere).

Thanks. Sean.

 

[PHV]

lstResult.RowSource = Replace(lstFilter.Column(2), "*", "Email")

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

 

[perrymans]

As usual PHV, you da man!

Works perfectly. Thanks. Sean.