Solved How to add two fields in my form t (1 Viewer)

SparkieDEV

New member
Local time
Today, 12:10
Joined
Oct 13, 2020
Messages
26
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:

Code:
            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

Super Moderator
Staff member
Local time
Today, 07:10
Joined
Feb 19, 2002
Messages
43,302
.Subject = Me.Title & "--" & Me.Type

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

SparkieDEV

New member
Local time
Today, 12:10
Joined
Oct 13, 2020
Messages
26
Perfect. Thanks.
 

SparkieDEV

New member
Local time
Today, 12:10
Joined
Oct 13, 2020
Messages
26
Fancy a stab at my other thread in the form forum? No one seems to be on point with it.
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 07:10
Joined
Feb 19, 2002
Messages
43,302
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.
 

Users who are viewing this thread

Top Bottom