Is it possible to have this code stored in a table then by selecting the appropriate item in a combo box in a form this code will be inserted. I'm using this code along with some other code in a couple of different forms. Depending on what form is picked the appropriate statements above will be selected. I've gotten it to work on some other bits of code but I'm not sure how to reference it this time. Do I have to setup a "Dim"?
I have about 30 pre-printed forms in Word that are going to be linked to Access. Mail merge won't work in this situation so I have a combo box to select which form I want to open. One of the columns on the combo box will list the specific code needed for each form. If it's not possible then I guess I'll have to setup a bunch of "if then" statements in the form's code.