I am having a problem getting my Query to use the SubForm value as search criteria.
I have:
Access version 2003
Mainform - Location Master Browse - Location Number
Subform - Location Account Browse SubForm - LocMast - Location Number
Query - Bank Master Browse Query - LocMast - Location Number
Results Form - Bank Master Browse Subform2 - LocMast - Loc Num
The Query is input for the Results Form. My criteria for the query is
[Forms]![Location Master Browse - Location Number]![Location Account Browse Subform - LocMast - Location Number].[Form]![ABA Routing Number]
When the Results Form is called the criteria is displayed waiting for a typed input. If I type in a valid answer the Results Form is displayed.
I have looked at this code until my eyes are crossed. Can someone see and explain what I am doing wrong. Any help would be greatly appreciated.
I have:
Access version 2003
Mainform - Location Master Browse - Location Number
Subform - Location Account Browse SubForm - LocMast - Location Number
Query - Bank Master Browse Query - LocMast - Location Number
Results Form - Bank Master Browse Subform2 - LocMast - Loc Num
The Query is input for the Results Form. My criteria for the query is
[Forms]![Location Master Browse - Location Number]![Location Account Browse Subform - LocMast - Location Number].[Form]![ABA Routing Number]
When the Results Form is called the criteria is displayed waiting for a typed input. If I type in a valid answer the Results Form is displayed.
I have looked at this code until my eyes are crossed. Can someone see and explain what I am doing wrong. Any help would be greatly appreciated.