Unbound list box and search

H

Harmannus

Hallo,

I have a unbound listbox (CPlist) that shows *all* my costumers based on a
query (qselCP). Can i filter the records of the listbox based on a search i
do?

The code that shows the search results:

DoCmd.OpenForm FormName:="frmCP", WhereCondition:=GetStrZoek

How can ik hook this up to the unbound listbox?
And resetting the unbound listbox to its *normal* state after i press the
filter off button (now i use Me.FilterOn = False)?

Thanx for any tips!

Regards,

Harmannus
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unbound listbox 0
me.recordsource? 3
Unbound listbox 4
Address unbound listbox 2
Sort unbound list box 3
Disable scrollwheel? 3
Multiselect List Box 4
Filter on subform using unbound text box 9

Top