Convert the code

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to Convert the code from a text field to code for a number field:
If Me.SpecificResultCode = True Then
If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and "
stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & ""
& (Trim(Me.SpecificResultCode)) & ""
End If
Thanks
 
I got it:
If Me!ChooseResultCode = True Then
If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and "
stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " &
((Str(Trim(Me![SpecificResultCode]))))
End If
 
Back
Top