userform log in screen will not recognise new entries

[cfinch100]

hi
ive built a log in screen that if you enter an unknown name frm8 pops up ,you enter name and company click save,problem is it does not enter it into main name
box or recognise it until both userforms are unloaded,although it shows on sheet2 its there,prob is can not seem to unload userforms fully to clear (memory),can
go back to main screen but sometimes that does not work,would like to enter name new or already there ,press next and it appears on next screen,it works if name is already there
cheers colin

[Charles]

Hi,

You keep changing your userforms. Your adding controls on them but are not using as far as I can see.
Hate to criticize, but you need to take your project step by step. Do not leave codes in that you are not using.
Do not put "Controls" on the form that you are using.
Format the code like a "Stair" case. Like the code that I modified for you.
Do not keep changing the "Forms" this causes you more problems. And, it's hard for the members to understand what your trying to achieve.
So, my suggestion for now is to rethink the procedure and make the necessary changes.

[cfinch100]

hi charles
yeh i admit im messy, will go though and get rid of rubbish not wanted,i think of something and try to make it happen get myself confused at times
cheers colin

[cfinch100]

hi charles
have stripped it down as far as i can and cleaned it up,would like userform8 and userform18 to act like frmissued (plant no)ie as you write a new number it enters it into box pop up form then writes it instantly to combobox9 and remembers it,have tried various codes but for some reason it will not remember new names until it is closed down and started again although you can select from drop down list,i removed code from combobox setfocus ect as it was playing havoc with scanner ,scan one box and would pertially enter code in next,but works fine now,some of userforms for reporting are not finished just 2 to go now ,any pointers to how to sort this problem out with entering new names would be welcome ,have used same code as the others but will not work obviously ive done smoethig
cheers colin

[Charles]

HI,

Why do you need to forms for logging in?
If you need the user to log in it should be done upfront.
Also if the person trying to log in is not on file you need to have the "Admin" add their name
so that they can access the file.
Now, not know, but will more than 1 user use the same file?
If so you may have a problem when having more than 1 user accessing the same file.

[IGEDIT]

I agree with Charles about logging in. This should be the first form to appear when the workbook is opened. One tip for you is to give all sheets and forms a name which is pertinent to their use e.g. the logging in form could be frmLogIn, this will make your code much easier to follow. I know from experience that some time down the line when you revisit the scene you will have forgotten most of what you have done before.