Well, I thought I had fixed my problem, but it still doesn't seem to be working how I intended it to. I had wanted to create a query that would display information about employees if their termination date fell between MM/DD/YY and MM/DD/YY. The query is made, and I added two unbound text boxes (named CORStart and COREnd) to the form that runs the query. I would like the query to read the dates entered in the text boxes and display all matching data, but instead a pop-up box asks me the dates every time the query is run. This would not be a problem, but when there are 4 queries pulling information all between these dates, the user would not want to enter the start and end dates four consecutive times. I know there has to be a way to make each query read the dates entered in the unbound text boxes, but I'm having some trouble getting it to do that. I read some previous posts, but the code isn't doing what I had thought it was supposed to. Heres how it looks now:
Between [Forms]![Security]![CORStart] And [Forms]![Security]![COREnd]
Any suggestions on getting it to work. Every time I put in the "Where" command in the beginning, Access tells me that it can't recognize that command. Thanks in advance,
Ben
Between [Forms]![Security]![CORStart] And [Forms]![Security]![COREnd]
Any suggestions on getting it to work. Every time I put in the "Where" command in the beginning, Access tells me that it can't recognize that command. Thanks in advance,
Ben
