John
What i mean is that i want to loop through the subform recordset and find the 3rd column value
Ahmed
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, January 31, 2012 10:50 PM
Subject: RE: [MS_AccessPros] Combobox column value
Ahmed-
The expression in VBA to get the third column of a combo box on a subform in
code behind the main form is:
Me.NameOfSubformControl.Form!NameOfComboBox.Column(2)
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Lahaina, HI)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of ahmad beshari
Sent: Tuesday, January 31, 2012 10:31 AM
To: ms_access_professionals@yahoogroups.com
Subject: [MS_AccessPros] Combobox column value
Dears
I have a form with subform, a Combobox with 3 columns is one of the subform
controls .By clicking a Buttom in the main form i like to read the
value for the third column in the combobox Is there any way to do this?
thanks
Ahmed
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar