Well before I start with my question or idea I did try to search a bit but honestly I didn't know what to search for. If after reading this you know what I need to look for please feel free to point me in that direction.
Anyways... I have a form that is going to be adding parts from our storage inventory to a database. We just re-boxed everything in the warehouse and per a great suggestion from our business manager we had to enter everything into a notebook because she, "thought it would be best to have a hard copy as well". Ehh, whatever.. I won't get into all that. Now what I'm wondering is that is there a way to setup some sort of AfterUpdate or other event that would allow the user to enter a part number, and upon moving to the next field if that part number has already been entered before, let it update the Description field automatically.
I currently only have one table where information is entered. Which includes a Primary Key (autonumber), Box Number, Part Number, Quantity, Description, Specific Part Notes, and Entry Date.
Now, we have close to 700 boxes with anywhere from 1 to like 20-something different part numbers in it. And of course since this isn't a perfect world there are plenty of boxes with duplicate parts and sometimes the same or different quantities (the owner is a packrat, lucky me). I've got the description field set as a combo box, and it will display unique entries only, since we have parts that have different part numbers but the same description (i.e. AC Push Button). The combo box will auto-complete as you start to type the description, which is great. I just was thinking that it would be even cooler if there was a relatively simple way to skip that as well if the that part # had been entered before at some point during the data entry process, because it could speed things up that much more. Then the user would only have to bother typing in that field if it comes up blank.
Since the combo box thing auto-completes that is definately helping keep the descriptions consistant. I assume that the Part Number textbox could be setup to run some sort of query on the table and the first part number it comes across as a match, it reads the description from that then spits it out onto the form, and if not then nothing!
Sorry for the long winded explanation, I'm sure there is an easy answer I've overlooked. Any help (or links to threads that will help) will be much appreciated! This feature isn't a MUST HAVE but it would be nice.
Anyways... I have a form that is going to be adding parts from our storage inventory to a database. We just re-boxed everything in the warehouse and per a great suggestion from our business manager we had to enter everything into a notebook because she, "thought it would be best to have a hard copy as well". Ehh, whatever.. I won't get into all that. Now what I'm wondering is that is there a way to setup some sort of AfterUpdate or other event that would allow the user to enter a part number, and upon moving to the next field if that part number has already been entered before, let it update the Description field automatically.
I currently only have one table where information is entered. Which includes a Primary Key (autonumber), Box Number, Part Number, Quantity, Description, Specific Part Notes, and Entry Date.
Now, we have close to 700 boxes with anywhere from 1 to like 20-something different part numbers in it. And of course since this isn't a perfect world there are plenty of boxes with duplicate parts and sometimes the same or different quantities (the owner is a packrat, lucky me). I've got the description field set as a combo box, and it will display unique entries only, since we have parts that have different part numbers but the same description (i.e. AC Push Button). The combo box will auto-complete as you start to type the description, which is great. I just was thinking that it would be even cooler if there was a relatively simple way to skip that as well if the that part # had been entered before at some point during the data entry process, because it could speed things up that much more. Then the user would only have to bother typing in that field if it comes up blank.
Since the combo box thing auto-completes that is definately helping keep the descriptions consistant. I assume that the Part Number textbox could be setup to run some sort of query on the table and the first part number it comes across as a match, it reads the description from that then spits it out onto the form, and if not then nothing!
Sorry for the long winded explanation, I'm sure there is an easy answer I've overlooked. Any help (or links to threads that will help) will be much appreciated! This feature isn't a MUST HAVE but it would be nice.
