By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,939 Members | 1,670 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,939 IT Pros & Developers. It's quick & easy.

Form in Access with Subforms/Tabs

matrekz42
P: 37
Hello Gurus,

I currently have a form that houses multiple subforms and it's all on tabs, within the form.

I have a query that I want the date range to be called from a DatePickr that is in one of the tabs, but it doesn't recognize it. I tried the following:

Between [Forms]![Totals By Date]![Start] And [Forms]![Totals By Date]![End]

as the criteria for the date, but it didn't work because it's within a tab in the form.

All help is greatly appreciated. Thanks again!
Feb 21 '08 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,769
Have a look at Referring to Items on a Sub-Form and see if you can use the concept in your references.
Feb 22 '08 #2

matrekz42
P: 37
Have a look at Referring to Items on a Sub-Form and see if you can use the concept in your references.

That's some good stuff, but it didn't work, I think it's because I dont have a subform in the tab I'm trying to get the info from the date picker.

So I have the form, and within the form I have (TABS) and in the first tab I have a subform but in the rest I just want to set up criterias to run different queries, using date ranges.
Feb 22 '08 #3

NeoPa
Expert Mod 15k+
P: 31,769
I'm afraid I never work with a Date Picker. What I know is pretty well included in the article so if that doesn't work I can't help I'm afraid. Certainly not without something more specific to work with.
Feb 22 '08 #4

matrekz42
P: 37
I'm afraid I never work with a Date Picker. What I know is pretty well included in the article so if that doesn't work I can't help I'm afraid. Certainly not without something more specific to work with.

No problem, thanks for the heads up though!
Feb 22 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.