Button to open pdf, VBA

[dweekley]

I have a button that onclick would open a pdf file. I am getting a 'data type mismatch in criteria expression' messege.

I have checked and every thing, and all is short text in the table. I can see in debug that the cmbCUSTIDABBR has the correct value from the form.

'Open Customer Drawing


'Dwg. field empty
If Len(Me.txtDWG.Value & "") > 0 Then

Dim FL As String 'File Location
Dim FN As String 'File Name
Dim FLFN As String 'File Location \ File Name

FL = DLookup("[Dwg_File_Loc]", "t_Customer", "[CustomerID] = " & [Forms]![f_Estimate]![cmbCUSTIDABBR])
FN = txtDWG.Value
FLFN = FL & "" & FN & ".pdf"

txtFL = FLFN

Application.FollowHyperlink FLFN

Else

MsgBox "Drawing filename field is empty" _
& Chr$(13) _


& "Enter drawing filename to continue with opening drawing", vbOKOnly, "No Filename"

End If

What am I missing.

TIA

[pbaldy]

In the DLookup? See if this helps:

DLookup Usage Samples

[dweekley]

Sweet. All's good. One of these days I'll get the formatting down.

Thank you much.

David

[pbaldy]

No problem David.