Hi all,
I am creating a user friendly database for our small company and I have a very specific need that seems to be out of the ordinary. I have created a database that tracks the production, components, and component failures of the auto parts that we receive from various suppliers. We already have inventory software, this is something that can be used in house at our specific location so we can streamline some information gathering a bit.
Anyhow, I have created a form with a combo box that is intended to be used to autofill part of the form so we can avoid errors when entering in production information.
I found the Baldy autofill article be extremely helpful in the autofill part but then am not able to save the prepopulated information.
I attempted the suggestion at the bottom of the page to save the information but when I put in the VBA code into code builder as instructed once again by Baldy article about using VBA code, nothing happens. No autofill, therefore nothing to save.
Is there something I could be overlooking? I just need a combobox that autofills part of the form while the user fills in everything else so they will be able to click save record to add all info in the form to the table.
I am creating a user friendly database for our small company and I have a very specific need that seems to be out of the ordinary. I have created a database that tracks the production, components, and component failures of the auto parts that we receive from various suppliers. We already have inventory software, this is something that can be used in house at our specific location so we can streamline some information gathering a bit.
Anyhow, I have created a form with a combo box that is intended to be used to autofill part of the form so we can avoid errors when entering in production information.
I found the Baldy autofill article be extremely helpful in the autofill part but then am not able to save the prepopulated information.
I attempted the suggestion at the bottom of the page to save the information but when I put in the VBA code into code builder as instructed once again by Baldy article about using VBA code, nothing happens. No autofill, therefore nothing to save.
Is there something I could be overlooking? I just need a combobox that autofills part of the form while the user fills in everything else so they will be able to click save record to add all info in the form to the table.
