>Hi,
>Can someone please help? I display a grid to pick a record from. I want the user to pick a record (click, dblclick, whatever). The picking should release the grid and move the record pointer to the record they picked. In what event do I do this?
>
>Any help is greatly appreciated! I can not get this to work!
>
>Thanx,
>John
I suggest that you open the table twice, one to be used for the grid and the other for the form.
Once you click on the grid store the record number and release the grid, then go to the record number that you saved and refresh the form.