Please find attached a sample file. LE file.zip
I am looking for the following two changes.
1. In the form in the Date feild i want to show that as a list of months like Jan,Feb etc. How to edit the VBE code for this?
2. How do i overwrite a record that i entered. I mean i want to change the Amount field with other three fields being same in the form. Now it creates a new record and old data is still there. What do i need to change in the code.
Example: I want to overwrite the amount here.
Name Company Month Amount
Shekhar ABC Ltd Feb 10000
I can change the code with some trial & error method but cannot create that on my own. I have copied it from a exisitng file and changed to suit my requirements.