[AccessD] A2k - Refer to a combobox

Using assume textbox and combo names, you just need one line of code in the combo's afterupdate event....

Private Sub Combo2_AfterUpdate()
    Text0 = Combo2.Column(2)
End Sub

Note that to columns property has a zero based index.

Lambert 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of drcaa at click21.com.br
Sent: Tuesday, July 14, 2009 3:55 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] A2k - Refer to a combobox


Hi folks!
In a given form I created a combobox to read details of reports from a table.
There are 3 fields: ID (autonumber), name of report and a description. I would like to have that description (3rd field) passed to a textbox when I choose a report from the list.
Any help highly appreciated.
TIA,
--
****************************
* Carlos Alberto Alves
* mailto:drcaa at click21.com.br
* mailto:drcaa at predialnet.com.br
****************************

___________________________________________________________________________________
Para fazer uma ligação DDD pra perto ou pra longe, faz um 21. A Embratel tem tarifas muito baratas esperando por você. Aproveite!

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com