List Box

[Valentine]

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.

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]

save writing complicated code to do this and just open it again.

 

[CJ_London]

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]

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?