Name them as shown in Table A by double-clicking each to open its options dialog. Complete this process three times to add two text box fields and one dropdown field to the form. To add a field, position the cursor and then click the appropriate tool on the Forms toolbar. Display the Forms toolbar by right-clicking any toolbar and checking Forms.
To create the form, start with a blank document. Figure A Use the dropdown field to dynamically fill other fields. Specifically, the form retrieves data from the Employees table in the Northwind database (the sample database that comes with Access). The example form in Figure A lets you choose a last name from the dropdown field and then automatically fills in the remaining text box fields with corresponding data from an Access table. A field is a predefined cell for entering and storing information. A form is a Word document that contains fill-in blanks or fields, in which you enter information. To dynamically fill in Word fields from an Access table based on the contents of another Word field, you’ll need a Word form, an Access table with data, and some Visual Basic for Applications (VBA) code.
AUTO POPULATING FIELDS IN WORD HOW TO
This blog post was inspired by a message from TechRepublic member who asked: “Hello! I am desperately trying to figure out how to select a choice in a field in the beginning of my form and pre-fill the default values for other fields in the form based on that first dropdown choice.” Building the Word form Then, the same form uses the selected value from that field to retrieve more Access data. The example technique in this TechRepublic How do I… populates a Word 2003 dropdown field with Access data. That takes a bit more work than a simple mail merge, but it’s certainly doable. Perhaps you want to filter Access data based on the contents of a Word field. For instance, you might use Word’s mail merge feature to complete invoices in a Word form using customer data from an Access database. Fortunately, Office applications share data easily. Word lets you create and edit documents and Excel analyzes your data. The download includes a sample Access database and Word form.Įach Microsoft Office application specializes in a specific job.
AUTO POPULATING FIELDS IN WORD PDF
This blog post is also available in PDF form as a TechRepublic download. Each Microsoft Office application specializes in a specific job. The download includes a sample Access database and Word form. How do I… Dynamically fill Microsoft Word fields using Access data?
0 kommentar(er)
