Reading subform field

DAW

Registered User.
Local time
Today, 12:39
Joined
Mar 22, 2006
Messages
70
Probably really simple... but:

I have a main form with a command button on it. Also on the main form is a child form driven by a query, shown as a table. One of the fields shown from this query is 'ID'.

How do I get the ID of the currently selected record (that the user has clicked on in the subform table) when I click the command button? :confused:
 
Forms!mainformname!subformcontrolname.Form!ID

Or from the main form module:
Me!subformcontrolname.Form!ID
 
Forms!mainformname!subformcontrolname.Form!ID

Or from the main form module:
Me!subformcontrolname.Form!ID

Ahhh... simple as that - thanks Galaciom!
 

Users who are viewing this thread

Back
Top Bottom