Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Createing a report that links to a form that has subforms

Status
Not open for further replies.
Leaner79

Leaner79

Programmer
Joined
Jan 17, 2006
Messages
25
Location
BW
Hi,
I have a form, Patient..and it has 3 subforms..
I want to create a report that will show all data(including the data in the subforms)..
But only for the highlighted record.. The primary key for the main table is ingMasaNo
Please help
 
Sort by date Sort by votes
I am not sure I quite understand, but have you tried creating a report in a similar way to the form, that is, main report and subreports to match main form and subforms. You could then open the report from your form with something like:
[tt]DoCmd.OpenReport rptReport,,,"ingMasaNo=" & Me.ingMasaNo[/tt]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

telephoto
  • Locked
  • Question Question
Report waiting for printer before displaying results
Replies
3
Views
664
dhookom
dhookom
SamuelR
  • Locked
  • Question Question
Dlookup in a report
Replies
13
Views
1K
dhookom
dhookom
breezett93
  • Locked
  • Question Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
1K
dhookom
dhookom
FancyPrairie
  • Locked
  • Question Question
How to Format a date on a report
Replies
1
Views
759
sxschech
sxschech
PrimoSteve
  • Locked
  • Question Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
500
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top