I have a form which allows the user to search a Table named Articles. The results are displayed in a grid which is bound to a cursor named mycursor. When the user selects a record from the grid and subsequently press enter I want to store the value of my artikey field in mycursor and use that to to find the record on my main form as some of the fields are bound to the same table named Articles. In the keypress event of mycursor I have:
IF nKeyCode = 13
thisform.retval = mycursor.artikey
THISFORM.Release()
ENDIF
When this form is release all I know is that thisform.retval=mycursor.artikey. My main form is bound to the Articles Table. Therefore how do I use the contents of thisform.retval to find the record in Articles so that my main form which is bound to the Articles Table shows the correct record to the user?
Many THanks
Neil Lewis
IT R&D Manager
Velmore Ltd