I made a form which as a subform on it.
The subform has two columns.
I want to access the column data in the subform through event control
for example, OnDblclick event. If the subform displays the table as
below.
Column A Column B
-------- ----------
1 Data A
2 Data B <- 2nd row
3 Data C
... ...
-----------------------
When a user double click the in 2nd row either column A or column B,
the code should get the value 2 or "Data B" and, and it'll search the
record using one of the values and open a form to display the record.
So far, I succeeded to open a form but could not get the value on the
column. I only can display the 1st record in the table.