Hi All,
Could you please help me on my below two issues with the UserForm, which has a ComboBox with three different type of actions for data - To Add, To Update and To Delete.
1.) I want to restrict the value in the dropdown list, so I am just using "Match Required = True" in the ComboBox property.
I am getting an error message as "Invalid Property Value" while clicking on the combobox then try to jump/go to other Optionbuttons/ Textboxes.
Example: If I choose "Update" or "Delete" option, then the combobox displays the list of all the available records, but If I pick/select any record number from it, then delete that value immediately (just simply press "Delete" key"), and try to jump/go to another option like "Add" or Others, then I get this error message. Everytime I have to press the "ESC" key to bypass the error message. I am unable to figure out the perfect soultion of it.
2.) If you please look at my UserForm, here I am able to Add the new records, but I don't know why I am unable to "Update" or "Delete" any record properly.
Please help on both above points.
Thanks in Advanced!
Regards,
SunOffice
Bookmarks