Updating form with new entries

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
 
Use the Undo function to delete the changes to the current record.
 
Use the Undo function to delete the changes to the current record.


I've tried this but, if the user has deleted part of the text that they've put in (ie. they've typed "Smyth" insted of "Smith" and deleted back to correct the error), then tried to exit the field, it only deletes as much as has been typed in since part of the word was deleted (in the above example, "Sm" would still be left in the field).

Is there a "clear cell" or "clear field" function? I can't find anything. :confused:

Ronnie
 
I've tried this but, if the user has deleted part of the text that they've put in (ie. they've typed "Smyth" insted of "Smith" and deleted back to correct the error), then tried to exit the field, it only deletes as much as has been typed in since part of the word was deleted (in the above example, "Sm" would still be left in the field).

Is there a "clear cell" or "clear field" function? I can't find anything. :confused:

Ronnie
Are you using undo on the control or on the whole record?
 
Are you using undo on the control or on the whole record?


I was doing it on the control - have now worked out that if I RunCommand Undo twice in the macro, it clears the information I need clearing. Thanks for your help on this.

Ronnie
 

Users who are viewing this thread

Back
Top Bottom