I have a pretty simple question that probably has a pretty simple answer but I am still fairly inexperienced in Access so bear with me I'm more of a VB guy and Access has a little different twist but I do love it. now on to my question.....
I am writing an application and several of the forms require the user to enter various date ranges to search for the data based on when the data was entered. For instance, the user will enter a date from 01/01/04 to 06/01/04 and all the records that fall between those two dates will be reported. How do I write the program to where the user enters these two dates into an Unbound text box and then get the query to read this information directly from the text box?
in your query designer, right click in the criteria section of the field, choose "Build...". choose forms then go through forms till you find your date textbox is listed on the middle pane. double click the textbox then click OK. now it should be in the criteria section.
ofcourse you should use BETWEEN operator to make your query work in this case like:
BETWEEN Forms![DlgPrograms]![txtDate1] AND Forms![DlgPrograms]![txtDate2]