Open form from Table Frame view with mouse double click

You can't attach code to a tableview.

Is that your question?

Or are you talking about a tableframe on a form?

Tony McGuire
"It's not about having enough time; we have the rest of our lives. It's about priorities.

If you're talking about a tableframe, then this code may help. It is attached to "MouseDouble" in the object explorer for the 1st field in the tableframe. It takes the order number from that field and opens a new form with all the details of the order. Obviously you will need to change the names of your tables, fields and forms to suit but it does seem to work very nicely.

var
frm form
orderNum number
tc Tcursor
endvar

orderNum=custorder.value

if isedit() then endedit() endif
tc.open("Temp1")
if orderNum.isBlank() = false then
if tc.locate("custorder",orderNum) then
if tc.qlocate(orderNum) then ; use qlocate if client # is the primary key field, much faster.
frm.open("orderentry")
frm.custorder.movetorecord(tc)
;frm.custorder.setRange(orderNum) ; use setrange to keep the user from moving off the record
else
MsgStop("Error",ordernum.string()+" "+"Is Not a Valid Number")
endif
endif
endif
tc.close()

Lewy