D
Donteathecheese
I have been assigned to create a form for the company I work for and I have
ran into a few problems with some of the things I want to do. The form I am
creating is a request form, and shippment form.
I wanted the person that was sending the form to be able to go into their
contacts and select a person. After the person has been selected I wanted the
street address, city, state and zip to come into field within the form.
I also wanted the subject box to be autofilled in as fields are inputed.
here is some of my code.
Sub jobName_CustomPropertyChange(ByVal Text)
With Me
Set .jobNumber.text = .jobName.Text
End With
End Sub
This didnt seem to work and I was not sure why.
I also wanted to be able to press a button and send a reply back saying that
the shipment has been taken care of and I was completely lost on this.
If anyone could help me with these things or point me in the right direction
that would be greatly appreicated. Maybe even a book recommendations would be
greatly appreciated.
--Zac
ran into a few problems with some of the things I want to do. The form I am
creating is a request form, and shippment form.
I wanted the person that was sending the form to be able to go into their
contacts and select a person. After the person has been selected I wanted the
street address, city, state and zip to come into field within the form.
I also wanted the subject box to be autofilled in as fields are inputed.
here is some of my code.
Sub jobName_CustomPropertyChange(ByVal Text)
With Me
Set .jobNumber.text = .jobName.Text
End With
End Sub
This didnt seem to work and I was not sure why.
I also wanted to be able to press a button and send a reply back saying that
the shipment has been taken care of and I was completely lost on this.
If anyone could help me with these things or point me in the right direction
that would be greatly appreicated. Maybe even a book recommendations would be
greatly appreciated.
--Zac