List Box (1 Viewer)

Valentine

Member
Local time
Today, 06:30
Joined
Oct 1, 2021
Messages
261
I have a multiselect list box in my form and I have a button that prints what is selected to PDF. I want a message box to pop up that states to ensure the selected number is not already open in pdf view.

Code:
MsgBox "Please ensure that CNF " & me.lstBox.Value & " is not already open."

doesn't show the value in the message. The values in the list box are just numbers.
 

Ranman256

Well-known member
Local time
Today, 06:30
Joined
Apr 9, 2015
Messages
4,339
save writing complicated code to do this and just open it again.
 

CJ_London

Super Moderator
Staff member
Local time
Today, 10:30
Joined
Feb 19, 2013
Messages
16,553
The numbers are probably pk’s you need for your report. Try lstbox.column(1)

however use of lstbox.value implies it is not multi select. If it is you need to loop through the .selected items to gather the data
 

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Today, 05:30
Joined
Feb 28, 2001
Messages
27,001
Unless you have the Adobe library that enables you to manipulate .PDF files directly, you cannot have the situation you described for longer than a few seconds while Access is creating the entirety of the .PDF you are trying to publish. Do you actually HAVE the Adobe library?
 

Users who are viewing this thread

Top Bottom