Solved How to add two fields in my form t

[SparkieDEV]

Just a little code correction; I would like to combine two fields in my form to make the subject of my outlook appointment. Here is my code for one field, Title:

            If Len(Me.Title & vbNullString) > 0 Then
                .Subject = Me.Title

I would like my subject to formulate a combination of two fields: Title and Type, so the subject would display: "Type Title"

Thanks

 

[Pat Hartman]

.Subject = Me.Title & "--" & Me.Type

I included -- as a separator. Use whatever makes sense to you.

 

[SparkieDEV]

Perfect. Thanks.

 

[Pat Hartman]

You're welcome

 

[SparkieDEV]

Fancy a stab at my other thread in the form forum? No one seems to be on point with it.

 

[Pat Hartman]

As it happens, I already looked at it. In the future though, please include a link, don't make us have to search for the thread you want someone to look at.