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 SkipVought 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
Jan 17, 2006
25
0
0
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

SamuelR
  • Locked
  • Question
Dlookup in a report
Replies
13
Views
124
dhookom
dhookom
breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
102
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
63
sxschech
sxschech
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
47
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
180
caykamanj1966
caykamanj1966

Part and Inventory Search

Sponsor

Back
Top