ACCESS FEED: RE: [MS_AccessPros] Updating multiple textboxes from a combo box

Rabu, 15 April 2015

RE: [MS_AccessPros] Updating multiple textboxes from a combo box

Duane Hi

I use this Technical . why is not typically recommended

Thanks a lot
Domenico

Il 15/apr/2015 12:17 AM, "Duane Hookom duanehookom@hotmail.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> ha scritto:

Art,

You can set the control sources to expressions like:
=cboTenant_Unit.Column(1)

If you think you need to store the value from the columns in the combo box (not typically recommended) you would use code in the after update event of the combo box like:

Me.txtUnitID = Me.cboTenant_Unit.Column(1)

Duane Hookom, MVP
MS Access

Date: Tue, 14 Apr 2015 14:22:04 -0700
Subject: [MS_AccessPros] Updating multiple textboxes from a combo box
I have a combo box called cboTenant_Unit with a record source of:

SELECT qry_Tenant_List.CustID, qry_Tenant_List.UnitID, qry_Tenant_List.TenantName FROM qry_Tenant_List;

I display all three fields when it opens up. I also have two textboxes called txtUnitID and txtCustID. What I would like to do is update txtUnitID with the contents of UnitID and txtCustID with CustID from the combo box and updated as it changes content.

Is there a way to achieve this? I am guessing there is a way to reference each column in the combo box.

Thank you,
Art Lorenzini
Sioux Falls, SD