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
Tidak ada komentar:
Posting Komentar