VBA code for an If Statement

[gheyman]

I am struggling moving from Excel to Access VBA. Would someone be very kind and assist me with this one?

I need an If statement that states if [AnswerTo_Security]=[Security_Answer]

then [Text41]=[UserID_PWHint]

Else [Text41]="Incorrect Security Question answer"


[Text41] and [AnswerTo_Security] are both Unbound fields on my form.

[Security_Answer] and [UserID_PWHint] are both fields from a query to which the forms record source is - qryEmployeeLst

Very much appreciated!!

 

[ParamRay]

If the code is in the form's module, it should be as simple as:

If AnswerTo_Security.Value = Me.Security_Answer Then
  Text41.Value = Me.UserID_PWHint
Else
  Text41.Value = "Incorrect Security Question answer"
End

 

[gheyman]

Thank you Very Much! Truly appreciated.

I was trying to use IIF.