ronniepurpleuk
Registered User.
- Local time
- Today, 00:46
- Joined
- Aug 14, 2006
- Messages
- 16
Hi All,
I have a Job Log form whereby a customer name is entered, along with details of the job.
I have arranged it so that if the user tries to enter a new customer (ie. their details are not on the system), another form pops up in which to enter the new customer details. I have done this by setting the Limit to List to yes and running a macro to open the Customer Details form on Not In List in the events property of the Customer Name field (a combo box) in Job Log.
The problem I have is that in order to update Job Log so that the new name appears in the list, I have to delete the incorrectly entered data in the Customer Name field before Refreshing. I only seem to be able to do this manually but I would like this to happen automatically on closing the Customer Details form.
The problem is with deleting the data that has been typed into the Customer Name field in job log. Does anyone know a solution?
Thanks in advance
Ronnie
I have a Job Log form whereby a customer name is entered, along with details of the job.
I have arranged it so that if the user tries to enter a new customer (ie. their details are not on the system), another form pops up in which to enter the new customer details. I have done this by setting the Limit to List to yes and running a macro to open the Customer Details form on Not In List in the events property of the Customer Name field (a combo box) in Job Log.
The problem I have is that in order to update Job Log so that the new name appears in the list, I have to delete the incorrectly entered data in the Customer Name field before Refreshing. I only seem to be able to do this manually but I would like this to happen automatically on closing the Customer Details form.
The problem is with deleting the data that has been typed into the Customer Name field in job log. Does anyone know a solution?
Thanks in advance
Ronnie