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!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Controlling Sub Report Data
Hi, How can I set the recordsource of a sub report based on a field value in the main report. The field in the main report is simply the rank order of the records. The value of the field in the main report determines whether the query returns the top 10 records, the bottom 10 records or 5...- buskgrim
- Thread
- Replies: 1
- Forum: Microsoft: Access Reports
-
Syntax error - missing operator for OpenReport
Dan, OpenReport problem solved. Much Appreciated. Chris.- buskgrim
- Post #3
- Forum: Microsoft: Access Modules (VBA Coding)
-
Syntax error - missing operator for OpenReport
DoCmd.OpenReport "R:Test Report", , , "School =" & MyField The above reults in "Syntax Error (3075) missing Operator in query expression" The field variable is correctly picking up the values I want but the OpenReport method refuses to run (I am simply attempting...- buskgrim
- Thread
- Replies: 2
- Forum: Microsoft: Access Modules (VBA Coding)
