Help wih code

[Rmaster]

I've used the example from this site to import a word document to my access table. Now i want a check in VBA that if a field value is "Ja" and 2 other options are empty a Field in my table "Statusvca" changes from his standard value Closed to Open i've tried these codes and they dont work.

This is in the Form

    !Risico = doc.FormFields("fldRisico").Result
    !Vca = doc.FormFields("fldVca").Result
    !Vcaplus = doc.FormFields("fldVcaplus").Result

This i use for check

If doc.FormFields("fldRisico").Result = "Ja" And IsNull(doc.FormFields("fldVca").Result) And IsNull(doc.FormFields("fldVcaplus").Result) Then
    !Statusvca = "Open"
End If

    If !Risico = "ja" And IsNull(!Vca) And IsNull(!Vcaplus) Then
    !Statusvca = "Open"
    End If

Can anybody give me any suggestion

Thanks
Rmaster

 

[Rmaster]

I have it
it was just an option i hadn't tried

    If doc.FormFields("fldRisico").Result = "Ja" And doc.FormFields("fldVca").Result = "" And doc.FormFields("fldVcaplus").Result = "" Then
    !Statusvca = "Open"
    End If