Filter listbox to forms recordset (1 Viewer)

BJF

Registered User.
Local time
Today, 10:29
Joined
Feb 19, 2010
Messages
90
Hello,

Its been awhile and i cant figure how to do this:

I have a listbox on my form that shows company name [company], and theres a macro on the click to go to whichever record is slected from the listbox.

The query for the listbox is 2 fields: [ACCT] and [COMPANY]

[ACCT] is the primary key

I'm not sure what criteria syntax to put into the [ACCT] field of the query to match the listbox to my filtered recordset.

ex. i filter the form by using the filter by selection tool in the state field. It narrows my recordset from 100 records down to 10.
I want the listbox to show the same 10 records that have been filtered on the form now.

Any suggestions?
Thanks you
BJF
 

theDBguy

I’m here to help
Local time
Today, 07:29
Joined
Oct 29, 2018
Messages
10,071
Hi. I think you would have to match the Listbox RowSource with the RecordSource of the Form, so you can apply the same Filter to both of them.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom