How to get value of column from subform

N

Nova

In my subform (datasheet) has 4 column A, B, C and D. When I double click at
any column in record, I would like to get value of the column A from that
record to show on textbox on main form. How can I write code for this?
 
T

Tom van Stiphout

On Mon, 23 Nov 2009 21:05:01 -0800, Nova

In each of the 4 double-click events write:
Me.Parent.myControl = Me.A
(of course you replace myObjectNames with yours)

-Tom.
Microsoft Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Populate main form from subform record 0
Adding sequence numbers to paragraphs 0
Dynamic Naming of Form Button 3
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Cumulative formula for word table 0
DLookup in Continuous form 0
Merging from an Excel file with graphics 1
Optionbutton Not working 3

Top