I am trying to troubleshoot a Run-time error 2001 in a company databse. The form has 3 pages. The first page is just regular fields as to criteria looking for a rental. Page 2 has a subform attached that should shows filterd results of the criteria entered. Page 2 is where the problems are. The fields on the page (above the results window) are unbound as well as a text box beside it showing the info entered on page 1. There are 2 buttons on this page. One to filter by the info entered on page 1 (it copies in info from the text boxes into the unbound field), and the other to reset all the fields to IsNull. Regardless of the button you click or if you manually enter data into the unbound fields I get the same Run-time 2001 error. The code in the attachment is for both of the buttons and also the 'refresh query click' code that both of them runs. Not sure if anyone can give me any ideas as to what is going on. Because the code stops, the results window on this page is always ALL the properties, regardless of criteria entered.
This is my first thread so don't know if I can send the code for anyone to look over.
This is my first thread so don't know if I can send the code for anyone to look over.