Access Database Form

[aprilmarie]

I have a combo box that is populated with numbers from a table where it is the primary key (Cost Center #'s). I was hoping that when the selection was made it would populate a text box for the cost center's name. I have been fooling around with recordsets, but I can't get it to work.

Please help,

April

 

[LittleSmudge]

I don't think you need recordsets for this.

Assuming your CostCenterName is in the table along with the CostCenterNumber ( # means Date to people round here ).
Make the RowSource in the combo include the two fields eg:-
"SELECT CostCenterNo, CostCenterName FROM CostCenterTable"
and the BoundColumn = 1, RowCount = 2.

Then - EITHER
1) In the combo's AfterUpdate event put
txtBox = comboName.Column(1)

OR
2) In the combo ColumnWidth put 0cm;
This will then store the CostCenterNumber in the relevant field but the combo box itself will display the list of CostCenter NAMEs for the user to pick from and display the cost center Name in the box once selected. ( Thus doing away with the need for the additional textbox.



'ope-that-'elps

G LS