MRichmond
08-25-2011, 11:43 AM
Hi to all viewers.
I am looking for some help creating a user form, or more precisely making it work how I want.
I have a user form, where people are required to enter data needed to resolve customer service issues.
They should be able to enter a new record, or edit an existing record. They would be able to scroll through all records (I have this working, thx XLD), or search for a record using a unique log number.
So I am looking for the appropriate code to start my form blank, and then switch to view/edit existing record, when one of the lower command buttons are activated. I think I can figure out the Add New, Save and Cancel portions, once this little bit has been solved.
I am attaching a test workbook, and as always any and all help is really apprieciated.
I am looking for some help creating a user form, or more precisely making it work how I want.
I have a user form, where people are required to enter data needed to resolve customer service issues.
They should be able to enter a new record, or edit an existing record. They would be able to scroll through all records (I have this working, thx XLD), or search for a record using a unique log number.
So I am looking for the appropriate code to start my form blank, and then switch to view/edit existing record, when one of the lower command buttons are activated. I think I can figure out the Add New, Save and Cancel portions, once this little bit has been solved.
I am attaching a test workbook, and as always any and all help is really apprieciated.