How can I get the data in a subform?

[learner]

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.

[Bruce M. Thompson]

Response below.

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.

You should post your code if you want someone to analyze it, but you can try
this:

DoCmd.OpenForm "", , , "[Column A]=" & Me![Column A]

--
Bruce M. Thompson, Microsoft Access MVP
bt******@mvps.o rg (See the Access FAQ at http://www.mvps.org/access)

NO Email Please. Keep all communications

within the newsgroups so that all might benefit.<<