add a click (or double-click) event to your listbox, and add following code there:
docmd.openreport "myreport",,,"GroupID=" & me.Listbox1
BIG-DB wrote 23/04/2006 :
I have a list box listing a grp of records. I want to be able to click on a record listed in the box and it opens as a report.
Right now my users scroll down write down the record ID they are after. I have a open record button on the form and they then t
To answer please click on Q or A sign on the left of the subject.
Written and designed by
Send us your comments
Copyright © 1998-2007 by MAUG