if No selection on multiselection box then print all in listbox.

G

Gwen

Hi,
Please assist.
I am using a multiselection listbox that enters the bound column of the all
selections in a text box.

However if the user does not make a selection, I want everything in listbox
to be displayed in the report.

I have tried me.listbox.itemselected = false
then
DoCmd.OpenForm stDocName
else
DoCmd.OpenReport stDocName, acViewPreview, , stlinkcriteria
end if.
Doesn't work

Thanks
 
S

Sandra Daigle

Try checking the count property of the .ItemsSelected collection:

if me.listbox.itemselected.count =0 then
DoCmd.OpenForm stDocName
else
DoCmd.OpenReport stDocName, acViewPreview, , stlinkcriteria
end if
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combo Box Selection 1
Getting stuff out of Multiselection Listbox 3
Sort with Listbox Selection On Top 4
Print list box 3
Combo Box & Report Questions 22
Syntax for number of copies to print? 1
Opening a report based on a value of a column of combo list. 0
DoCmd. Openform Error Message IF no records found...not getting it 0

Top