Good morning. I just recently joined. Thank you!
I have created an Access database that houses all information on owner/operator truck drivers for our organization. There are several forms that need to be populated with the data that is being housed in the database.
I'm near the end of creating my database. I'm not a programmer, and I do okay with small codes. I have gotten a code that utilizes "unbound" text boxes, requesting input from the user. When button on form is clicked, it takes the data from the unbound form and populates it into the pdf form.
What I need to do is just modify the code so instead of needing input from the user (with the unbound text box), it takes data from fields already populated. I have created a subform (has relationship to main form "ID"), and it has the fields that are needed for my pdf form. I want it to be able to read the data in each field, and then pull that data and populate the pdf form.
I have created my database (Owner Operators3) where I want to put the code. When the database opens up, the main form opens. When I click on "Open Contract Info" it opens a subform. On the subform, there is a button "Command41" which is where I want to be able to add this code to.
I hope that someone can help me with this. I appreciate all comments and any help!! :banghead:
I have created an Access database that houses all information on owner/operator truck drivers for our organization. There are several forms that need to be populated with the data that is being housed in the database.
I'm near the end of creating my database. I'm not a programmer, and I do okay with small codes. I have gotten a code that utilizes "unbound" text boxes, requesting input from the user. When button on form is clicked, it takes the data from the unbound form and populates it into the pdf form.
What I need to do is just modify the code so instead of needing input from the user (with the unbound text box), it takes data from fields already populated. I have created a subform (has relationship to main form "ID"), and it has the fields that are needed for my pdf form. I want it to be able to read the data in each field, and then pull that data and populate the pdf form.
I have created my database (Owner Operators3) where I want to put the code. When the database opens up, the main form opens. When I click on "Open Contract Info" it opens a subform. On the subform, there is a button "Command41" which is where I want to be able to add this code to.
I hope that someone can help me with this. I appreciate all comments and any help!! :banghead:
