how to print the current record

[Ste]

Hi,

I would like to print the current showing record from the Form screen but
don't know where to start.

Here are what I have:

I can print any records from report built from query that has filter setup.
But if I am in data entry Form, and want to get the record displayed to
print out in the same format of report, I can't.

I try to add a button on the data entry Form, which opens another form with
a report button. But that would print all records. I don't want to enter
any more filter manually, instead I want it to go ahead printing by the
[form]![formName]![RecordPrimaryKeyName] that are on the screen, etc..

Any help is appreciated.

Ste

[biganthony via AccessMonster.com]

Ste,

I use something like the following to print the record currently on screen:
strWhere = "[ID] = """ & Me.[ID] & """"

DoCmd.OpenReport "ReportName", acPreview, , strWhere

Anthony

Ste wrote:

>Hi,

I would like to print the current showing record from the Form screen but
don't know where to start.

Here are what I have:

I can print any records from report built from query that has filter setup.
But if I am in data entry Form, and want to get the record displayed to
print out in the same format of report, I can't.

I try to add a button on the data entry Form, which opens another form with
a report button. But that would print all records. I don't want to enter
any more filter manually, instead I want it to go ahead printing by the
[form]![formName]![RecordPrimaryKeyName] that are on the screen, etc..

Any help is appreciated.

Ste

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1

[msg2hany]

Hi

You can do it by filtering the Query in the record source of the
Report

by putting in th ecriteria of the linked field (EmployeeID) for
example

[Forms]![FormName]![FieldName]

You can find many similar exmaples and others on the followin g:

http://www.access-forum.com/plus/viewforum.php?f=41

Hany
www.access-forum.com
biganthony via AccessMonster.com :

Ste,

I use something like the following to print the record currently on screen:
strWhere = "[ID] = """ & Me.[ID] & """"

DoCmd.OpenReport "ReportName", acPreview, , strWhere

Anthony

Ste wrote:

Hi,

I would like to print the current showing record from the Form screen but
don't know where to start.

Here are what I have:

I can print any records from report built from query that has filter setup.
But if I am in data entry Form, and want to get the record displayed to
print out in the same format of report, I can't.

I try to add a button on the data entry Form, which opens another form with
a report button. But that would print all records. I don't want to enter
any more filter manually, instead I want it to go ahead printing by the
[form]![formName]![RecordPrimaryKeyName] that are on the screen, etc..

Any help is appreciated.

Ste

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200705/1