Type MisMatch Error Associated With Dlookup Function On Form

[R Tanner]

Any ideas why I would get a Type Mismatch error when I try to run this
via code?

Dim MyInt As Long

MyInt = Me.SelectUnAppTicket.Column(1)

Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets", MyInt =
"[UnapprovedTickets]![PTID]")

 

[Douglas J. Steele]

Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets",
"[UnapprovedTickets]![PTID] = " & MyInt)

Of course, there's no reason for MyInt:

Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets",
"[UnapprovedTickets]![PTID] = " & Me.SelectUnAppTicket.Column(1))

 

[R Tanner]

Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets",
"[UnapprovedTickets]![PTID] = " & MyInt)

Of course, there's no reason for MyInt:

Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets",
"[UnapprovedTickets]![PTID] = " & Me.SelectUnAppTicket.Column(1))

--
Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
(no private e-mails, please)

Any ideas why I would get a Type Mismatch error when I try to run this
via code?

Dim MyInt As Long

MyInt = Me.SelectUnAppTicket.Column(1)

Me.UnAppST = DLookup("[Start Time]", "UnapprovedTickets", MyInt =
"[UnapprovedTickets]![PTID]")

Yeah, I know, but I was having problems both ways, so I was just
trying to find a solution by trying different things...