Help with populating my user form

[Quicksnot]

just want to say thanks ahead of time, i attached the workbook with a userform, i'm not sure if this is the best way to gather information
or not. i have to add about 1200+ machines, the boss wants to go from an old fashion rolodex to digital rolodex, so this is what i came up with
so far. you guys have always pushed me past the finish lines with your help and deeply appreciated, unfortunately my boss is always changing things,
which i don't mind doing because you guys are awesome.

Thanks
Keith

[torachan]

what you are developing is a 'pseudo database' using a spreadsheet - the data should be on one row per item and recalled to a template page for display.
forget about storing your data in a presentation format - it will become an inefficient nightmare for data retrieval - the larger it grows in that sort of format the slower it will become until it grinds to a halt.
just a brief look, I would suggest you store the 'item' details in one table and cross referenced to a second table that contains the 'actions' or 'movement' details of that item.
you need to accommodate three basic events 1)data entry, 2)data editing, 3)data removal into your form.
I have attached a simple demo form which you can quite easily expand upon - most of the code flow is almost like reading a book and understandable.

[Quicksnot]

Thank you for your response. i will attempt to add on from here, and will repost what i have figured out and could use your expertise to help me finish this program, unfortunately my
boss would like it to look like the old fashion rolodex card when he Puches up the number of the machine to show what dates the machine was taken there and how long before we brought in
an upgraded machine for example, but 1st just to let You know what i mean, so say in 2012 we brought a brand-new pool table to one of his customers (a tavern, we supply juke boxes, pool tables, dart boards, pinballs)
to over 150 places, and he tries to update them with newer equipment, or the taverns will call another vendor, so all our machines are on paper still on a rolodex, and we write down the date we take them a new machine,
and that way he knows how long it's been and where it's at to get a newer machine. so i will replace employee number with machine number, and so on and add in a couple more boxes and columns if i can figure it out, and
i really could use your help, when i make a small userform and put in a machine number and another userform pops up and shows the location, the date the machine was delivered, and all the locations of where its been
so the location doesn't accidentally get the same machine back.

i hope this helps you understand what my boss is asking of me and are willing to help

Thanks
Keith

[torachan]

divorce the 'visuals' from the 'data storage' in a 'rolodex' your boss can only look at and absorb the information of one card at a time - this is easy enough to emulate on a UserForm.
Set up a dummy form with all the data fields that you store at present and put the data field headers on columns on one sheet with some fictitious info in about 10 - 20 rows.
Post and upload that back on this site and I will show you what I would propose.

[Quicksnot]

Thanks torachan

i like it so far i made another text box and changed the words, but the location column doesn't populate, because i don't know how , and i added something off to the side
of the button for history, don't know if thats possible or not, but would be a big help for us. if i messed up your sheet i'm sorry, still learning.

Thank Again
Keith

i did it, i figured out the location problem, i just changed it from 1 - 3, to 1 - 4

but would still like to put a machine number in the yellow box and BINGO!!, shows all the locations where that machine has been, of course it will still need the date that the machine went there so we have an idea of how long its been there.