DLookup returning null value no matter what I do

[Silver Lining]

I have a table 'tblContacts'. It has what you would expect to find with regards to fields in a contact db. It includes the [ID] field as well as a [CompanyLogo] field that looks up the value from a table called 'tblCompanyProfiles'

I am attempting what I would think is a very simple lookup to search the tblContacts, locating the contact ID I want and then returning the value in field [CompanyLogo].
No matter what I have tried, it seems to always result in a null value. I can confirm that the contact ID that I am using is valid and it has data in [CompanyLogo].
My tired eyes would appreciate your help.

Private Sub Command56_Click()


  Dim companyID As Variant
  Dim ownerID As Long

On Error GoTo Command56_Click_Err


    On Error Resume Next
    If (Form.Dirty) Then
        DoCmd.RunCommand acCmdSaveRecord
    End If
    If (MacroError.Number <> 0) Then
        Beep
        MsgBox MacroError.Description, vbOKOnly, ""
        Exit Sub
    End If
    If (Form.NewRecord) Then
        Beep
        Exit Sub
    End If


  


    ownerID = Me.Owner.Value ' From the current form and is a number
    MsgBox "ownerID " & ownerID  ' I get the correct value here.
    


    companyID = DLookup("First Name", "tblContacts", "ID = " & ownerID)  ' I have attempted numerous variations of this statement, but it always returns nothing.
    MsgBox "companyID " & companyID


Command56_Click_Exit:
    Exit Sub


Command56_Click_Err:
    MsgBox Error$
    Resume Command56_Click_Exit
End Sub

[June7]

You are pulling value from First Name, not CompanyLogo.

Also, since field name has space, need to use []: [First Name]. Don't use spaces and punctuation/special characters nor reserved words as names in naming convention and you can avoid this frustration in most cases.

What purpose does it serve to annoy user with a popup message just to tell them this info? Is this just for testing? What do you really plan to do with this value? Should be able to show this info in a textbox on form.

If you want to provide db for analysis, follow instructions at bottom of my post.

[davegri]

'On error Resume Next' will mask any error that exists. Comment out that line and see if it shows you an error. Does the field ownerID exist in tblContacts? Seems more logical that it would be in tblCompany, if you have it.

[Welshgasman]

When you get like that. Stop, and come back to it later. Generally you will spot the error then.
As mentioned, you are not even using the correct field, but you still should be bringing back something unless they have no first name for that ID?
Though if it is a company perhaps there is no first name?

[Silver Lining]

My apologies. I was testing different fields to see if there was something specific about the actual field I was targeting. I failed to change it before I sent the cry for help.

I will re-test with brackets [CompanyLogo]

Thank you

[Silver Lining]

Thank you. [] did the trick. Something so simple, but when you can't see the trees from the forest because its been frustrating you for so long.

Thanks again.

[June7]

CompanyLogo does not have space nor special characters. Brackets are not required but don't hurt. CompanyLogo without brackets should have worked.