Brain Gone Soft

[UKBobby]

Isn't it funny - you don't use access for a few short months and its back to the drawing board.

I gave a question - how can I get users to enter data into a form (to populate a table), then by clicking on a button get a report printed but only to print the current record.

I think this is possible via macros but as I say my brain has gone soft.

Many thanks in anticipation

 

[SforSoftware]

Hi Bobby,

Welcome back in the real Access-world

Indeed you can do this with a macro, with the action OpenReport. In the arguments you can give a WHERE-statement. There you say "ReportsIDField=Forms!YourForm!txtIDfield"
(see Help for more about the syntax of the WHERE-statement)

 

[ghudson]

Check out this link...

Print only the current record to a report

HTH

 

[jtvcs]

You can also use two actions in a macro...

RunCommand with Command argument = Select Record
Printout with Print Range argument = Selection

HTH JT