I am developing a form based on a query that joins two tables to display service call information. The customer requesting service is selected from a combo box and then their service records are displayed. If the customer has never requested service the previous customers service records are displayed and I have been unable to create a new record for the selected customer. I am using DCount to see if any records exist for the selected customer and if not a GoToRecord command is executed to create a new record but I keep getting a runtime error telling me that the system cannot find the requested record. The query this form is based is is set up to show all customers but only those service records that match a customer.
New Record Problems
- Thread starter clauses
- Start date
Fizzio
Chief Torturer
- Local time
- Today, 20:04
- Joined
- Feb 21, 2002
- Messages
- 1,885
How are you filtering records on the form - via a form filter or from a parameter in the query. How I have done this is to base the form on a parameter query and in the criteria for CustomerID, set it to the value of your Combo and on the After_Update just use me.requery to filter the form (A downside of this is that it does not goto the record, it filters out all other records so you cannot browse other records). If there are no records for that customer, it will automatically go to a new record.
HTH
HTH
