DLookup In Conjunction With MS Word

[Rmaster]

Hello all,

I have a query based on input from a word document. Now i want it to check if the data is the same as in the table but i cant get it work. You can see my query as attachmend. The name of the query is qryAchter2


My VBA Code is as follow

    If doc.FormFields("fldAchternaam").Result = DLookup "[tblAanvrager.Achternaam]", "[qryAchter2]") And doc.FormFields("fldGeboortedatum").Result = DLookup "[tblAanvrager.Geboortedatum]", "[qryAchter2]") Then
    PopUpMsgBox "Test ", , " Warning!!!", vbInformation
    Else

Can somebody help me to make this work

Thanks in advance

 

[Rmaster]

nobody?
please

 

[Rmaster]

thanks for the reply

I solved it a other way