Formatting ouput of userform when invoking a modification

[darbar76528]

greetings everyone!

i was wondering if someone could help me fix a problem i am having with a userform. the problem i am having is when the userform is initialized and a customer is selected from the top combobox, the information is populated below in the userform as it is supposed to, however, when i change a field (eg: Month or Notes) and then press the "Modify Existing information" command button, the code places first name then last name onto sheet1 instead of last name, first name. i know the code is performing as it is written, but i need the output of the name to follow the aforementioned style when the oModify routine is ran. any suggestions?

thanks in advance for any assistance you can offer!

david

(see attached worksheet)

[BadlySpelledBuoy]

In your "oAdd" sub you have this:

Please Login or Register  to view this content.

But in your "oModify" sub you have this:

Please Login or Register  to view this content.

Need some consistency with that and all should be fine.

BSB

[darbar76528]

when i make the change to

Please Login or Register  to view this content.

then the problem is

Please Login or Register  to view this content.

the vba code does not recognize at this point that this is a duplicate customer which is in need of just a modification of information on sheet1. as a result, the code asks if you want to add a new customer or cancel. if i click "yes" to add new one, the code inserts a new duplicate entry and the name is not formatted correctly.

does anyone have any ideas around this problem?

many thanks in advance!

david