Printing single record from Listbox

[Benzer420]

I have created a report which is actually envelopes based on query [OTHER CLUB DATA]. I have a form [Club Envelopes] with a list box showing all the other clubs and whilst I can print the report with all the envelopes, I need to be able to print just a single envelope based on the list box selection.

Appreciate any help.



Benzer420

[orange]

I recommend you show us some code. It appears that there is no constraint to limit the "records" to be printed. (just a guess)

[pbaldy]

One way:

http://www.baldyweb.com/wherecondition.htm

[Benzer420]

Many thanks for the quick response. I did however figure out the issue lying bed last night and with the code I had written it was losing focus of the required data.

Thanks again.