Rocky Smolin
rockysmolin at bchacc.com
Thu Feb 10 18:58:47 CST 2011
I'd look at the record source for the report. But if you want to print a report of just that record, I would pass the PK of the record you want to print and in the _Open event set the report filter to just that record's PK. HTH Rocky Smolin Beach Access Software 858-259-4334 Skype: rocky.smolin www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ralf Lister Sent: Thursday, February 10, 2011 4:42 PM To: accessd at databaseadvisors.com Subject: [AccessD] Recordset Movements Hello, In a form I enter the name of a person, the person's gender and some other stuff and store the entire data in a recordset with AddNew/Update. Then I calculate the pension of this person and store it in the same set. Finally I go to a report and want to print out the person's name, his gender and his pension. Therefore the pointer of the recordset has to point at the last set, right? But I put this rst.MoveLast in the Report's Load-Event with no success at all. I always get the very first set in my report. But I want the last. What can I do to get what I want? Saludos Actuary Ralf Lister La Paz, Bolivia Registrado en ASFI No. Registro: Act.Mat. 001 NIT: 1016725022 Skype Name: ralf.martin.lister Tel.: 222 26 61, Cel. 70136531 rlister at actuarial-files.com www.actuarial-files.com Environment