Johnny C
Well-known Member
- Joined
- Nov 7, 2006
- Messages
- 1,069
- Office Version
- 365
- Platform
- Windows
I've got a database that looks after problem logs. The users want to be able to pick all queries that relate to 3 fields, Account#, Workstream and update_status. They've asked for a combobox that lists those 3 and the number of logs that relate to each combination.
So I've created a query that generates those and uses that as the source for a 4 column combobox.
I figured to set BoundColumn to 0 to give me the (n-1)th item in the list (i.e. first item - 0).
How can I now pull the (n-1)th row from the query to identify the 3 fields in the Combobox selection, so I can select the rows from the database to populate a subform that satisfy the 3 fields in the Combobox selection?
Cheers
Johnny
So I've created a query that generates those and uses that as the source for a 4 column combobox.
I figured to set BoundColumn to 0 to give me the (n-1)th item in the list (i.e. first item - 0).
How can I now pull the (n-1)th row from the query to identify the 3 fields in the Combobox selection, so I can select the rows from the database to populate a subform that satisfy the 3 fields in the Combobox selection?
Cheers
Johnny