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
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