This has been the most aggravating 90 minutes I have ever had using Access. I tried to create a form with a Navigation control on it. I could have built most of a dB in that time.
No wonder I never use the navigation control. What a royal pain in the neck....only 2 feet lower!! (I'm tall) I want to say all kinds of bad words and throw things!
But back to the problem. Now that my BP is back down, this is the code I used to test the text boxes:
Code:
Private Sub btnOne_Click()
MsgBox [Forms]![mainform]![NavigationSubform].[Form]!tbStart
MsgBox [Forms]![mainform]![NavigationSubform].[Form]!tbEnd
End Sub
So I created a query that used a table with a couple of date fields. I pulled down a couple of date fields and added criteria to it. In the next blank column, I pasted in[Forms]![mainform]![NavigationSubform].[Form]!tbStart. In the next column I pasted in [Forms]![mainform]![NavigationSubform].[Form]!tbEnd.
I had 2 records with dates that in the ranges. Here is the SQL
Code:
SELECT Calls.[Opened Date], Calls.[Due Date], [Forms]![mainform]![NavigationSubform].[Form]![tbStart] AS StartDt, [Forms]![mainform]![NavigationSubform].[Form]![tbEnd] AS EndDt
FROM Calls
WHERE (((Calls.[Opened Date])<=[Forms]![mainform]![NavigationSubform].[Form]![tbStart]) AND ((Calls.[Due Date])>[Forms]![mainform]![NavigationSubform].[Form]![tbEnd]));
Then I switched the criteria to the BETWEEN criteria:
Code:
SELECT Calls.[Opened Date], Calls.[Due Date], [Forms]![mainform]![NavigationSubform].[Form]![tbStart] AS StartDt, [Forms]![mainform]![NavigationSubform].[Form]![tbEnd] AS EndDt
FROM Calls
WHERE (((Calls.[Due Date]) Between [Forms]![mainform]![NavigationSubform].[Form]![tbStart] And [Forms]![mainform]![NavigationSubform].[Form]![tbEnd]));
Again I had 2 records.
So everything seems to be working. Your path seems to be correct.
Only thing left would be for you to post your dB.