Thank you. I noticed the adofiltersearch.recordset.fields(ClickChoice).value - (or close to that) about 2 hours after i'd posted!
Again, thanks for your help, i now have a very nice filter search working!
I am currently using an ADO control with visual basic.
This piece of code is *supposed* to display the fields of ClickChoice (what i clicked in the list box) in another list box. However it seems I can't use the variable ClickChoice when trying to connect the DB...