Filter Listbox

T

Tor_Fey

Registered User.

Local time

Today, 04:47

Joined

Feb 8, 2013

Messages

121

• May 8, 2018

• #1

Good Afternoon;

I am trying to filter multiple listboxes from one core listbox with an onclick event.
On the core (main) listbox I have the following onclick event:

Code:

Me.writeoffdetails.Column(0) = Me.vatdetails.Column(0)
    Me.companiesdetails.Column(0) = Me.vatdetails.Column(0)
        Me.tradingprem.Column(0) = Me.vatdetails.Column(0)
            Me.directordetails.Column(0) = Me.vatdetails.Column(0)

But this is returning the following error: “Run-time error ‘424’ – Object required”

Can you guys give me a pointer where I’m going wrong?

Kind Regards
Tor Fey

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 20:47

Joined

Aug 30, 2003

Messages

36,272

• May 8, 2018

• #2

That might set the value of a listbox (don't think you can use the Column property), not filter it. Filtering would be like:

http://www.baldyweb.com/CascadingCombo.htm

 

arnelgp

..forever waiting... waiting for jellybean!

Local time

Today, 11:47

Joined

May 7, 2009

Messages

20,339

• May 8, 2018

• #3

Create a query for the other listbox that will be filtered:

Select Column1, column2 from table where column1=Forms!formName!vatDetails;

Use this as the rowsource of the combos to be filtered.

On the AfterUpdate event of vatDetails combo, Requery the other combo:

PrIvate sub vatDetails_AfterUpdate()
me.writeoffdetails.requery
Me.companydetails.requery
Me.tradingprem.requery
Me.directordetails.requery
End sub

 

pbaldy

Wino Moderator

Staff member

Local time

Yesterday, 20:47

Joined

Aug 30, 2003

Messages

36,272

• May 8, 2018

• #4

Like described in the link...