match data type

  • Thread starter Thread starter sg
  • Start date Start date
S

sg

Hi,

I have a unbound text box, which is link field "account". data type of
account is text .in the account_afterupdate event, my coding is
Me.RecordsetClone.FindFirst "[Account] = " & Me![Account]

But it gives me the error " the data type is not matched". Since I cannot
change the type of source field which is in linked table. How can I do this
to make my text box as text.

Thanks for your help.
Sarah
 
Hi sg,

I think it is a syntax issue. Try this:
Me.RecordsetClone.FindFirst "[Account] = '" & Me![Account] & "'"

Hope this will help
 
Hi JL,

It works perfectly. Thanks so much.
Sarah
JL said:
Hi sg,

I think it is a syntax issue. Try this:
Me.RecordsetClone.FindFirst "[Account] = '" & Me![Account] & "'"

Hope this will help


sg said:
Hi,

I have a unbound text box, which is link field "account". data type of
account is text .in the account_afterupdate event, my coding is
Me.RecordsetClone.FindFirst "[Account] = " & Me![Account]

But it gives me the error " the data type is not matched". Since I cannot
change the type of source field which is in linked table. How can I do
this
to make my text box as text.

Thanks for your help.
Sarah
Click to expand...
Click to expand...
 
Back
Top