I have a form named frmAuditData which is a NavigationSobForm on the form "Navigation Form". On the frmAuditData I have two fields... txtStartDate and txtEndDate.
Then in a query design I have this code which is supposed to display the records in tblAuditData but it doesn't work:
Between [Forms]![frmAuditData]![txtStartDate] And [Forms]![frmAuditData]![txtEndDate]
I've also tried:
Between Forms![Navigation Form]!frmAuditData.Form!txtStartDate and Forms![Navigation Form]!frmAuditData.Form!txtEndDate
But that doesn't work either. When I run the query I get an enter parameter value form twice.. once for txtStartDate and once for txtEndDate
Nota that the date fields in the table look like: 9/8/2015 1:42:39 PM if that matters.