E
Enigo
Hi I am having issues concatenating a text field. The field contains details
of when a call back has happened. I want to concatenate into one field. I
have tried using the following SQL statement (Thanks Duane) but with little
sucess.
Contact Details: Concatenate("SELECT Details of contact made FROM
tblDebtors WHERE Customer Name =""" & tblCustomerDetails![Customer Name])
I get the following error:
Run Time Error: Method 'Open' of object '_Recordset' failed
When I debug it relates to the following line of code:
rs.Open pstrSQL, CurrentProject.Connection, _
adOpenKeyset, adLockOptimistic
Can anyone help?
of when a call back has happened. I want to concatenate into one field. I
have tried using the following SQL statement (Thanks Duane) but with little
sucess.
Contact Details: Concatenate("SELECT Details of contact made FROM
tblDebtors WHERE Customer Name =""" & tblCustomerDetails![Customer Name])
I get the following error:
Run Time Error: Method 'Open' of object '_Recordset' failed
When I debug it relates to the following line of code:
rs.Open pstrSQL, CurrentProject.Connection, _
adOpenKeyset, adLockOptimistic
Can anyone help?