Hi everybody!
I have another problem:
I have a table (Contas) whitch has two columns: Conta / Nome.
The data type for conta is text (it will accept exactly 20 numbers)
The problem is that using the Dlookup function a message appears saying:
"Datatype mismatch in criterian expression."
If Not IsNull(DLookup("nome", "contas", "conta = " & Str(Me.txtverifica))) Then
Nome = DLookup("nome", "contas", "conta = " & Me.txtverifica)
Else
DoCmd.GoToRecord , "Contas_Segmentation", acNewRec...
end if
Does anyone know how i can use this function with a string?
Tks,
I have another problem:
I have a table (Contas) whitch has two columns: Conta / Nome.
The data type for conta is text (it will accept exactly 20 numbers)
The problem is that using the Dlookup function a message appears saying:
"Datatype mismatch in criterian expression."
If Not IsNull(DLookup("nome", "contas", "conta = " & Str(Me.txtverifica))) Then
Nome = DLookup("nome", "contas", "conta = " & Me.txtverifica)
Else
DoCmd.GoToRecord , "Contas_Segmentation", acNewRec...
end if
Does anyone know how i can use this function with a string?
Tks,