I have a form that is based on a query of 2 tables: 'Job Number Table' and 'Client Table'. The form automatically displays
all of the relevant info in text box fields based on a combo box (CboJobNumber) that selects the job number. That is, the
user selects a job number from the combo box, and the rest of the form updates to include all of the relevant info for that
job, like client name and address, site details etc.
Now the complicated part (at least for me) is that i would like to have another combo box down the bottom of the form that
selects information from a different table [Employee Table] that includes an OLE object (a small signature image as .bmp). I
just can't figure out how to get the signature onto the form based on the result of the combo box (CboEmployeeName).
I think i need some VBA code that After Update identifies what the combo box selection is (which is linked to the [Employee
Table]), finds that record from the [employee table] and then grabs the corresponding OLE object (the signature) and puts it
into a field on the form.
Now i should say that the whole point of this is that i am trying to get these fields onto a form so that i can use all of
these form fields to populate a Word template (into corresponding bookmarks). I have the code already to get the word doc up
and running, just without the signature showing up..... So i will also need to figure out how to get the image from the
Access Form into the Word Bookmark. ie: will this work
Private Sub CmdBtnMrg_Click()
Dim SignatureVar as Object
SignatureVar = CboEmployeeName
'Start MS Word
Dim Wrd As New Word.Application
Set Wrd = CreateObject("Word.Application")
'Open up Template
Wrd.Visible = True
'Replace Bookmarks with data
.Item("SignatureBookmark").Range.Text = SignatureVar