Selasa, 14 April 2015

[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

__._,_.___

Posted by: dbalorenzini@yahoo.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar