data management system using userform

Hi, Im trying to make a data management system based in excel, and i have alot of questions that needs help with. Previously, i tried making individual example workbooks and posting a new thread for every question that i have. In the end, because every answer is tailored to each specific question, i had a hard time trying to combine them together in the actual workbook. So now im posting the workbook that im working on so that anyone who wants to help has a clear picture of where im going.

Maybe i will start by asking this question:
in the userform under "Sample manager" tab, combobox7 takes data from sheet "Case Log" column A. What i hope to achieve in combobox8 is that it populates only with values that contain 2 hyphens. For example, user selects DVI-00001 in combobox7, combobox8 should only show DVI-00001-001 and DVI-00001-002 instead of including DVI-00001-001-1 and DVI-00001-001-2.

Attached workbook for reference (file is over 2MB so had to compress it)

Hi Mike, Thank you for your reply.
It worked however, when I clicked on TextBox 22, an error message "Compile error: Variable not defined" pops up in the code at TextBox 21, highlighting " i "
at For i = 22 To 29

Please help!
Thank you

Hi mike, thanks for the above explanation. Could you help me with the following problems please?

In the following code, im trying to check if textbox21 is blank. if it is then stop the commandbutton from going further. And also, check if users missed out filling in any enabled textboxes after they key a number in textbox21. if there is, stop the code. Somehow i must have coded it wrongly as it does not proceed even though users corrected the mistakes after the prompt.

Please Login or Register  to view this content.

Hi mike, waiting for your expert advise

Thanks mike. I have uploaded the current version that we are working on. difference is the addition of more tabs, but shouldnt affect the problem that i have above

Hi mike, thanks for tidying up my codes, really appreciate it. Being a novice, i cant help but just plug someone else's code in and see if it works without much consideration. Will work on improving it as i go along. Regarding this code

Please Login or Register  to view this content.

What i was hoping is that if users forget to key in the empty textboxes, the prompt appears (which it does) telling them which one they had missed out. And until they have filled in all required fields (based on what is the number they key in textbox21) the info should not go into the worksheet (which it does now). I tried adding a "Exit Sub" after Next j but it stalls the code there. How would you code it for that to work?

Hi mike, hope i'm not interrupting your busy schedule, but was wondering if you can find time to help me on this. There are still alot more questions that i need answers to and i hope to finish this within the next month or so

thanks mike. I have an issue with this part of the code

Please Login or Register  to view this content.

its supposed to add a -n to the back of the value in combobox8 and it should continue the sequence where it left off. For example, i select DVI-00001-001 in combobox8 and add 1 sample to it, the sample name should be DVI-00001-001-1. it works fine on the first run. but if users select DVI-00001-001 again and add 1 more sample to it, the sample name becomes DVI-00001-001-1-1 instead of DVI-00001-001-2. Can you help me with that please?

Hi mike, the code is not working as desired. It is adding to the wrong number. When i tried it on DVI-00004-001, it added DVI-00004-002 instead of DVI-00004-001-1. Can you please help me resolve that?

Thank you so much mike!