473,386 Members | 2,078 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Print acSelection (i.e. single record) from subform

Hi,
I have a form containing a subform. I have placed some vb within the
subform to print the current record. When I use this vb from within
the main form, it prints all of the records for the individual (i.e,
the main form). I only want it to print the current record though.

This is because the vb is not specifically selecting the subform as
the 'focus'
or 'current' form. eg:

Private Sub Command309_Click()

DoCmd.PrintOut acSelection, , , acMedium, 1, False
(this needs to refer to the subform specifically)
End Sub

Anyone know how to do it?

Thanks, Nick.
Nov 12 '05 #1
0 2178

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: Robert | last post by:
I have this set as the onclick event procedure for a command button on a form: Private Sub cmdPrintRecord_Click() Dim strReportName As String Dim strCriteria As String strReportName =...
4
by: William Bradley | last post by:
What I need to have happen is, that when the form is filled out by the user, the user can produce a report of that record only. Any help would be appreciated. Thank you. William Bradley...
2
by: Paul Mendez | last post by:
I have a form that consists of 150 records and is still growing. there are times when I want to print a certain record of the form, say record 12. I go to file --> print and choose the page number...
10
by: Fendi Baba | last post by:
I am new to MS Access so please bear with me. I am trying to create a report format and attach a button to a form. This would users to print-out a record that they are looking at. I can report a...
6
by: jweaver | last post by:
I have set up an event to print a single record report in access with the criteria below, however each time I enter a claim ID to preview a report, I am able to see the correct claim ID but the...
1
by: Steve Eccles | last post by:
I'm trying to print out only the current record from my form in a report but each time all the records print out. How can I print only one record using a report. I have place a button in the...
2
by: Greg (codepug | last post by:
acCmdPrint allows me to print using the Windows Dialog. Since I want to be able to select the printer of my choice, this works well. I put his behind a button on a single form. The problem is,...
1
Jerry Maiapu
by: Jerry Maiapu | last post by:
Hi Please help. How can I delete i single record in a datsheet subform from main form using a delete button on the parent form.? i will be more grateful for your help... jm
2
by: simulationguy | last post by:
I have a report that prints all of the records out from a table, usually executed from a reports menu. The user also wants a print button on the data entry form that will print out the exact same...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.