I have a query that searches my customer table to look for existing customers. The results of the query are displayed in a split form where you can choose which customer you are looking for. There are 3 buttons on this form: HOME takes you back to the main menu, GO TO opens the Customer form to the matching ID, and NEW is supposed to open the Customer form to a new record. It's not. Clicking NEW opens the Customer form, but I get an error message saying that it could not go to the specified record. This is the code I am using:
Thank you both for your suggestions. However, after trying both of them, neither of them work. Both open the correct form, however it is blank, there are no fields to fill in. The subform is not there, the buttons are not there, nothing. What am I missing?