Trying to open a form by double clicking a field on another....

[Guest]

(Access project connected to SQL Server)
This shouldn't be this hard, lol...
Anyway, I have a form. I want to double click a text field and have it open
another form with that record. Simple, right? This is connected to a
datawarehouse, so there is not what I would call a regular index or key field
in quite a few of the tables, if that makes a difference. The code I have on
the double click event is:

Private Sub ITEM_SVCD_DblClick(Cancel As Integer)
Dim strDocName As String
Dim strCriteria As String

strCriteria = "[ITEM_SVCD]=" & Me.ITEM_SVCD
strDocName = "SVC_Item_Rollup"
DoCmd.OpenForm strDocName, , , strCriteria
End Sub

But when I fire the event, I get :
Run-tme error '3':
Closing delimeter not found for the string beginning at position 79 in the
command. The string begins with:')}) AS RS_586.

I haven't a clue.....

many thanks

 

[Guest]

Mybe, I had a similar problem, but it was because of the odbc connection and
not with access.

I can't have an access to the write syntax from my computer, but when you
configure the odbc connection, in the third or forth form, when you click on
next, you have something call string appending (or something like it, its the
top line) remove it, and then try.
If youll get no other responed, I'll come back to you with the exact terms
tommorow.