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!

Report object as parameter for query

Status
Not open for further replies.
Vidar13

Vidar13

IS-IT--Management
Apr 4, 2001
90
US
Can a report object be used for a parameter criteria in a query? I know that a form can be, using the

[Forms]![FormName]![Field]

In this instance, it would take on the value of "field" for the current, active form value and use it as criteria for the query.

[Reports]![ReportName]![Field] doesn't seem to work the same way. Is there another way of structuring the syntax?
 
Status
Not open for further replies.

Similar threads

TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
810
PizMac
PizMac
Trob70
  • Locked
  • Question
There is no object in this control 1
Replies
9
Views
1K
Trob70
Trob70
Moss100
  • Locked
  • Question
Create a Report from a query and then personalise the report for each client - possible?
Replies
2
Views
367
dhookom
dhookom
Bennie47250
  • Locked
  • Question
Report Crashes
Replies
2
Views
355
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top