Form in Access with Subforms/Tabs

[matrekz42]

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!

[NeoPa]

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

[matrekz42]

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.

[NeoPa]

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.

[matrekz42]

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!