Printing a specific record, via report

eliXiR

New member
Local time
Today, 06:59
Joined
Feb 20, 2009
Messages
1
Hello everyone,

I'm glad I found this fourm, looks very useful :)

Last week I was searching over the net for an Order Management template, for the place i'm working at. I came by a very good template.
After finishing editing it for my needs, I couldn't find a way to print an Order via Report.

In general, I need to print a Single Record via Report, and not all the Records in the table.

The link to the file of the template (not what I edited at my work) is:

http://office.microsoft.com/en-us/templates/TC010185481033.aspx?CategoryID=CT101426031033

(The wanted form is the main form, "Add and Edit Orders")

If anyone could do it on the template itself and upload it, or just give me an explanation, i'll be so greatful!

Thanks in advanced. ;)

edit:
I found this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=166662&highlight=Print+form

We asked the same question, but I dunno how to use codes in access :(
 
Last edited:
There are a number of steps to consider.

1) create a form and place a combo box on the form listing all the records. Ensure that each record has a unique identfier and have this as the first column in the combo box.
Hide this column by setting its width to zero.

Create your report.

Use the button wizard to open you report in preview mode.

There are two ways now to filter your data, either specify the filter when the report is opened, or have the filter in the query that is the recordsource of the report.

using the last approach you you would refer to the hidden ID column on your form, in the query criteria =Forms!YourFormname!YourComboName
 

Users who are viewing this thread

Back
Top Bottom