By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,423 Members | 1,601 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,423 IT Pros & Developers. It's quick & easy.

how to print the current record

P: n/a
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
May 23 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

May 23 '07 #2

P: n/a
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
May 26 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.