Susan Zeller
szeller at cce.umn.edu
Tue Feb 25 14:50:47 CST 2003
Julie, Off the top of my head, what I would do is put the ID of that record on the form somewhere -- could be hidden. Write a sproc for yoru report that accepts the id as an input parameter. Then, point the input parameters property to the id textbox on your form. A Print command button on your form can open that report and the report will print the current record. --Susan -----Original Message----- From: Julie Reardon-Taylor [mailto:prosoft6 at hotmail.com] Sent: Tuesday, February 25, 2003 2:38 PM To: dba-sqlserver at databaseadvisors.com Subject: RE: [dba-SQLServer]Sending parameters to a report Okay. That works great! Now, I get a parameter box where the proper lot# can be entered for printing bar coded labels. But, my access 2000 program was able to see where the cursor was located and print just that record. Is there a way to do that in an adp? I've tried me.currentrecord as well as some others, but what I want the user to be able to do is click on a record and print that particular one. Any ideas? Julie Reardon-Taylor PRO-SOFT OF NY, INC. www.pro-soft.net _________________________________________________________________ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com