Is your question about how to figure out which row in the data to use?
Moving the pointer in a grid moves the pointer for the underlying RecordSource at the same time, so finding the data is a matter of looking at the current record for the alias that's populating the cursor.
Is your question about how to program the double-click to do what you want?
Is your question about how to figure out what data is used to populate column 14?
The code : ThisForm.Text1.Value = ;
Evaluate(This.Parent.Parent.Column14.Text1.ControlSource)
was what I needed.
To clarify my need: I have a grid with production lot information. Job number, part number, PO number, etc. The user would find the job number in the grid for a project and double click it and the PO number would be captured for further processing.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.