Sam Summers
Registered User.
- Local time
- Today, 04:14
- Joined
- Sep 17, 2001
- Messages
- 939
Hi,
I have 6 subforms that i want to use on multiple forms.
So to save creating a great many additional subforms and associated queries i am trying to make the subform queries dynamic.
At the moment i have this in the query criteria:
[Parent]![LocationRef]
But it isnt working?
The subforms work on their own with these queries but on the form they just show empty fields.
I can't link them them because the main form is using a cross tab query.
Anyone have any ideas?
Many thanks in advance
I have 6 subforms that i want to use on multiple forms.
So to save creating a great many additional subforms and associated queries i am trying to make the subform queries dynamic.
At the moment i have this in the query criteria:
[Parent]![LocationRef]
But it isnt working?
The subforms work on their own with these queries but on the form they just show empty fields.
I can't link them them because the main form is using a cross tab query.
Anyone have any ideas?
Many thanks in advance