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

Query Filter Question

Status
Not open for further replies.
avagodro

avagodro

Technical User
Aug 12, 2005
83
US
I have a query that I have that generates a report from one particular form that is opened.
I have several different forms that have the main form and a subform within the form. The subform on each is what is different. I would like to have it so that it can generate the report from any of the forms.
The problem that I have is that the particular field that the query is using is in the subform. The criteria that I have in the query is: [Forms]![Hotels_Customers_pending]![Complaints Subform].[Form]![ComplaintID]

Is there a way that I could "eliminate" the [Forms]![Hotels_Customers_pending] portion? All of the subforms are named [Complaints Subform].
 
Status
Not open for further replies.

Similar threads

serino
  • Locked
  • Question
Help with a Query. 1
Replies
13
Views
558
strongm
strongm
combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
3K
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
871
TheresAlwaysAWay
TheresAlwaysAWay
Moss100
  • Locked
  • Question
Append query dropping leading zero 2
Replies
4
Views
800
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
644
JimStrand
JimStrand

Part and Inventory Search

Sponsor

Back
Top