Hi,
The title doesn't really make up the question as there is a fair bit more to it but, here goes.
I have a listbox on a form which is populated by a query on a table with 6 columns.
One of the columns intTextLength is an integer containing the number 1 or 2.
I wish for the user to only be able to select rows in the listbox where intTextLength adds up to a maximum of 8
i.e. 8 rows where intTextLength = 1,
or 4 rows where intTextLength = 2
or combination of intTextLength like 2 rows where intTextLength = 2 and 4 rows where intTextLength = 1
I hope this all reads ok. Anyway I look forward to your reply.
Thanks
The title doesn't really make up the question as there is a fair bit more to it but, here goes.
I have a listbox on a form which is populated by a query on a table with 6 columns.
One of the columns intTextLength is an integer containing the number 1 or 2.
I wish for the user to only be able to select rows in the listbox where intTextLength adds up to a maximum of 8
i.e. 8 rows where intTextLength = 1,
or 4 rows where intTextLength = 2
or combination of intTextLength like 2 rows where intTextLength = 2 and 4 rows where intTextLength = 1
I hope this all reads ok. Anyway I look forward to your reply.
Thanks