Hi all
I have a report which shows all clients, i want to print off the same report one record only, is this possible?
many thanks
maintt
How did you get on with single record being printed?
If you are still needing help suggestion is as follows:
Open your form in design view, then Press F11 on the keyboard to open the Navigation Pane. Then Select MACROS. In macros create a new macro, then select the action to open a report, in the arguments below select the report to open, change the Print option to Preview and below there you will see conditons. In the conditions select the elipses button to the right it will open the build wizard, then select table section and find your table then in the next column select a field which will hold unique information like an id field, then place in the = (equal sign), then select the form section and find your open form in design view, and in the middle column select the ID field.
Save and and close the macro.
Then drag the macro into your form (it will create a button for you), then save your form, change the view and when you have selected a record you want to preview click the button.