B
BillA
This my second posting of a problem I errantly checked as answered.
I am using Allen Browne’s great Search Form [
http://www.allenbrowne.com/ser-62.html ]. The record source for this form is
a query of numerous tables.
My problem is with a concatenated field in my query that converts seven
check boxes to their field namesakes. The fields are alpha-numeric; 24A;
24B; 67E; 105; 111B; 202 & PELL – pretty random stuff. Any number of the
fields can be selected. Therefore, the queried records field “Sections†is
just as random and look like this:
24A, 24B or
24A or
111B, 202 or
PELL
I am introducing unbound checkboxes to the Search Form that will represent
the check boxed fields mentioned. I want to add to the present code, which
filters queried records to include the additional condition – but I am going
nowhere. Any advice in developing code that would allow me to look at the
unbound check boxes and build a condition that will work with the Sub that
filters the queried records would be very appreciated.
Thank you,
Bill
I am using Allen Browne’s great Search Form [
http://www.allenbrowne.com/ser-62.html ]. The record source for this form is
a query of numerous tables.
My problem is with a concatenated field in my query that converts seven
check boxes to their field namesakes. The fields are alpha-numeric; 24A;
24B; 67E; 105; 111B; 202 & PELL – pretty random stuff. Any number of the
fields can be selected. Therefore, the queried records field “Sections†is
just as random and look like this:
24A, 24B or
24A or
111B, 202 or
PELL
I am introducing unbound checkboxes to the Search Form that will represent
the check boxed fields mentioned. I want to add to the present code, which
filters queried records to include the additional condition – but I am going
nowhere. Any advice in developing code that would allow me to look at the
unbound check boxes and build a condition that will work with the Sub that
filters the queried records would be very appreciated.
Thank you,
Bill