How to enable multi select listbox selections to filter report (1 Viewer)

pbaldy

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:12
Joined
Aug 30, 2003
Messages
36,125
Are the textboxes in the detail section? If so, are there multiple pages and you need to click on the navigation buttons at the bottom?
 
V

vent

Registered User.
Local time
Today, 09:12
Joined
May 5, 2017
Messages
160
pbaldy said:
Are the textboxes in the detail section? If so, are there multiple pages and you need to click on the navigation buttons at the bottom?
Click to expand...

Yes, there are text boxes in the detail section of the report. I have attached a couple of screenshots of the report when the selections are made
 

Attachments

  • progcodes.PNG
    progcodes.PNG
    27.2 KB · Views: 97
  • report.PNG
    report.PNG
    12.3 KB · Views: 88
pbaldy

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:12
Joined
Aug 30, 2003
Messages
36,125
It's difficult to decipher with little slices, but it appears the report is 24 pages long, so includes a lot of records. Are they only for one code? It also appears to need adjusting. ;)
 
V

vent

Registered User.
Local time
Today, 09:12
Joined
May 5, 2017
Messages
160
pbaldy said:
It's difficult to decipher with little slices, but it appears the report is 24 pages long, so includes a lot of records. Are they only for one code? It also appears to need adjusting. ;)
Click to expand...

Well I know now the code works because I for a fact there are 12 records with the program code 1212 but there's also MANY more records with the value *NOCODE I attached two new screenshots that show what I mean.
 

Attachments

  • 1212.PNG
    1212.PNG
    30 KB · Views: 91
  • 22.PNG
    22.PNG
    10.3 KB · Views: 87
pbaldy

pbaldy

Wino Moderator
Staff member
Local time
Today, 06:12
Joined
Aug 30, 2003
Messages
36,125
Did you include the asterisk in the criteria? Might be confusing since that's a wildcard character. I haven't tested having that in the values. Did you try that in your sample db?
 
V

vent

Registered User.
Local time
Today, 09:12
Joined
May 5, 2017
Messages
160
pbaldy said:
Did you include the asterisk in the criteria? Might be confusing since that's a wildcard character. I haven't tested having that in the values. Did you try that in your sample db?
Click to expand...

The only time I used the asterisk was when adding that field value *NOCODE not anywhere else in the query, but if its a problem in general i will get rid of it and simply say NOCODE
 

Attachments

  • samplereport.PNG
    samplereport.PNG
    8.4 KB · Views: 87
You must log in or register to reply here.

Similar threads

C
Solved FAYT Listbox Tab
Replies
15
Views
678
MajP
MajP
B
Filtering from a multiselect listbox with other filters
Replies
5
Views
343
bonzitre
B
zelarra821
Button to Select All and Delete selected items in a List Box
2
Replies
29
Views
774
zelarra821
zelarra821
oxicottin
Solved Move selected to top of listbox
Replies
11
Views
445
Pat Hartman
P
oxicottin
Solved Multiselect listbox loop showing there isn't data
Replies
4
Views
247
pbaldy
pbaldy

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Top Bottom