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 Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Update RecordSource in SubReport

Status
Not open for further replies.
ptiernan

ptiernan

IS-IT--Management
Apr 29, 2003
55
GB
Hi, I have a problem with our Access 97 application. I have created a form that works just like a query builder with a number of options, after OK is pressed the form opens a report and outputs the data as filtered in the form. Within the form use case and if loops to generate the WHERE condition I wish to use in my DoCmd.OpenReport method as below.

DoCmd.OpenReport "R_Client_Into_Training", acViewPreview, , where_stat

The problem arises when I want to run a report with several subreports in it. There are 4 different subreports with 2 with one WHERE condition and 2 with another.

Within the form I have 2 hidden text fields with both options for the WHERE condition.

I don’t know if I want to be updating the RecordSource for the report and if so when and how to do it.

Much Thanks
Paul Tiernan
 
Status
Not open for further replies.

Similar threads

2009luca
  • Locked
  • Question
put value in input box web page
Replies
0
Views
261
2009luca
2009luca
sal21
  • Locked
  • Question
scrping in listbox in a web page
Replies
0
Views
620
sal21
sal21
Andrzejek
  • Locked
  • Question
Hyperlinks in Word cut at #
Replies
2
Views
491
Andrzejek
Andrzejek
R
  • Locked
  • Question
reversed words in english leading new english words
Replies
10
Views
718
Chriss Miller
C
Andrzejek
  • Locked
  • Question
Data Type in ADODB.Recordset
Replies
6
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top