Using Date values from Form for criteia in Query

[Freddie81]

Hi Guys

I'v got a bit of a hick up in my database. I've got a navigation form called MainF, and one of the nav buttons pens a form called ReportingF which is used to open various othe forms in a subform field called DS. As per my screenshot I'm trying to use a date picker to assign a start date and an end date for my reports to run via Queries. The dte fields are on the fom ReportingF.

I need my query to get these values frm the form and run the query according to that criteria as per the second image. The criteia I used is in the image but it is not working, it gives me a blank datasheet but when I run the frm itself and then the quey it works.

[ranman256]

You said the form is ReportingF
but your screenshot says MainF.

the query needs ReportF.
forms!reportingF!txtStartDate .....

[Freddie81]

Nu uh, I said I have a Navigation form called MainF and it opens a new form called ReportingF inside it

Itried using ReportingF in the query and when I use the for stand alone it works but whn used ia th navigation form it doesnt

[June7]

So the date controls are on ReportingF? Then why does your criteria expression reference just MainF? Show your code for referencing ReportingF. Review https://www.accessforums.net/showthread.php?t=32053

[Freddie81]

Hi June7I attemtep to try the query from MainF as it is the navigation forms name that the ReportingF form shows into when you click Reportig on the nav form

If I have ReportingF open by itself the query works but when I use the navigation Form to access the reporting one it doesnt nd asks me to ente the values for the 2 text boxes fr dates

This is what my query now looks like:
Between [Forms]![ReportingF]![txtStartDate] And [Forms]![ReportingF]![txtEndDate]

[June7]

Did you review thread in the referenced link? Referencing subform whether on a normal or navigation form is different than referencing form opened independently. Same structure will not work.

I do not use dynamic parameterized queries. I use VBA to set Filter property.

[Freddie81]

I just read it yes, thank you very much, the criteria you gve that guy with the navigationsubform works.

[Freddie81]

Okay so I need to take it one level further lol


So the code: Forms![MainF]![NavigationSubform].Form!controlname allows access to the date picker on the navigationsubform, but where from here do I go to get access to the combobox in the form underneath that loaded in DS? Ive tried all of the things I could from the availabe options and its not giving e the control name.

[Freddie81]

Im trying this code in my query but its not working ither lol. I need the quey to only show th records for the specific customer selected in cboCustomr on the form.

"[CustomerName]='" & [Forms]![MainF]![NavigationSubform].[Form].[Controls]![DS].[Form].[cboCustomer] & "'"

[June7]

No idea. I don't use Navigation form.

If you want to provide db for analysis, follow instructions at bottom of my post.