HOW CAN I PRINT ONE RECORD IN A REPORT

[lorenzor]

Hello,

I've been trying to print a single record of a form with the specific data on the screen but with different format on printing.

I have done a report with the wizard, with the two queries I needed in the form, but the thing is that the report gets all the records and I just need: the record screened in the form.

Can you tell me how can I resolve this?
Thanks in advanced.
Erick.

 

[JohnLowell]

You need to know the unique identifier. You can then filter the report for that unique identfier.

Let me know if this helps.

 

[lorenzor]

Hello John,

I have searched about this unique identifier, but I couldn't find where its located, I got in the macro window, and I tried to filter the registers , but I couldn't do it, I read the access help about this, but still dont know how to do it.

I have the report, but still shows all the records and I just want the record screened, if you want I can send an email with a sample of the database i have, for you to know exactly what I'm doing.

Thanks for your attention.
Erick.

 

[JohnLowell]

Send a sample to john@legacyboston.com

 

[Garridon]

This web site has the answer to what you're looking for:

http://www.mvps.org/access/

Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[lorenzor]

Hola Linda,

your help was really good, but still cant make it work. if you want I can send you a sample of what I've done, for you to know exactly, where is the problem.

Thanks your help.
Erick.

 

[Garridon]

Let me ask this: The code in question is designed to work from a form open to the specific record. Is this how you set it up?



Linda Adams
Visit my web site for writing and Microsoft Word tips:

http://www.hackman-adams.com

Official web site for actor David Hedison:

http://www.david-hedison.com

 

[lorenzor]

Gracias (thanks) John!

everything is doing good now.

Erick.