S sf129 Registered User. Local time Today, 22:08 Joined Mar 6, 2003 Messages 11 Apr 2, 2003 #1 I have a query in Access 2000 that needs to use the data from a text box as criteria. So the text box calls for a date and the query in Access uses that date as the criteria date. How is this done?
I have a query in Access 2000 that needs to use the data from a text box as criteria. So the text box calls for a date and the query in Access uses that date as the criteria date. How is this done?
K KevinM Registered User. Local time Today, 22:08 Joined Jun 15, 2000 Messages 719 Apr 2, 2003 #2 Reference the form and text box in your query criteria under the date field... [Forms]![FormName]![TextBoxName]
Reference the form and text box in your query criteria under the date field... [Forms]![FormName]![TextBoxName]
S sf129 Registered User. Local time Today, 22:08 Joined Mar 6, 2003 Messages 11 Apr 2, 2003 #3 That would work if it was a form created in access, my form is created in visual basic, the form will run as a stand alone application.
That would work if it was a form created in access, my form is created in visual basic, the form will run as a stand alone application.
