From a Text to a Number Field

[ksimmsa]

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

 

[MajP]

= stLinkCriteria & "[dbo_customers.QuitCode] = '" & (Trim(Me.SpecificResultCode)) & "'

 

[ksimmsa]

thanks. i figured it out

If Me!ChooseResultCode = True Then
If stLinkCriteria <> "" Then stLinkCriteria = stLinkCriteria & " and "
stLinkCriteria = stLinkCriteria & "[dbo_customers.QuitCode] = " & ((Str(Trim(Me![SpecificResultCode]))))
End If

 

[PHV]

And why not simply this ?
stLinkCriteria = stLinkCriteria & "dbo_customers.QuitCode=" & Me!SpecificResultCode)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886