Print selected record in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with a subform. THere is no relationship between the 2 as the
main form only contains buttons for running different options and the subform
is the datasource set in datasheet style. I need to print a selected record
from the subform, but have not been able to figure this out. Any suggestiosn?
 
Follow the logic in this article:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
and change the line:
strWhere = "[ID] = " & Me.[ID]
to:
strWhere = "[ID] = " & Me.[Sub1].Form.[ID]
where Sub1 represents the name of your subform control.

(This assumes the button is on the main form. If it's on the subform, you
have nothing to change.)
 
Thanks for the reply, my solution is very close to yours. and I think
yhours is a little better as I do not have to filter a single record first.
Here is my solution

Dim stDocName As String

stDocName = "rpt:Current Trial Balance"
DoCmd.OpenReport stDocName, acNormal, , Forms![frm:CUrrent TB]![Current
TB subform].Form.Filter

Yours also checks for dirty records, which I never considered.
--
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf


Allen Browne said:
Follow the logic in this article:
Print the record in the form
at:
http://allenbrowne.com/casu-15.html
and change the line:
strWhere = "[ID] = " & Me.[ID]
to:
strWhere = "[ID] = " & Me.[Sub1].Form.[ID]
where Sub1 represents the name of your subform control.

(This assumes the button is on the main form. If it's on the subform, you
have nothing to change.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Cyberwolf said:
I have a form with a subform. THere is no relationship between the 2 as
the
main form only contains buttons for running different options and the
subform
is the datasource set in datasheet style. I need to print a selected
record
from the subform, but have not been able to figure this out. Any
suggestiosn?
--
James Gaylord
Finder of Paths, Hunter of Prey
Ghost of the Night, Shadow of Day
The Wolf
Click to expand...
Click to expand...
 
Back
Top