Hello,
I have a form with a list box that gets populated according to the selection made in dynamic combo boxes. The list box is updated starting from the selection in the combo named cbofilterStudies.
In my examples, please look at the selection “Age Study”.
I am having a problem with the query as cannot work out how to add multiple criteria.
In my sample db, you will notice that the last combo (which I have named txtRP) has 4 different selections. The list box only gets update with the first two but not with the others. Not sure how to manage this query.
My idea was to query at least 4 different fields in the table.
The other issue is that the txtcount1 textbox that counts the number of records in the list box. I have used the -1 as it always counts an extra records but if no records are selected, I get a -1.
Thank you for any help.
I have a form with a list box that gets populated according to the selection made in dynamic combo boxes. The list box is updated starting from the selection in the combo named cbofilterStudies.
In my examples, please look at the selection “Age Study”.
I am having a problem with the query as cannot work out how to add multiple criteria.
In my sample db, you will notice that the last combo (which I have named txtRP) has 4 different selections. The list box only gets update with the first two but not with the others. Not sure how to manage this query.
My idea was to query at least 4 different fields in the table.
The other issue is that the txtcount1 textbox that counts the number of records in the list box. I have used the -1 as it always counts an extra records but if no records are selected, I get a -1.
Thank you for any help.