Total Access amateur here.
I have a bound Department Name combo box (Combo18) and unbound Dept. Cost Centre textbox (Text33).
When I choose a Department Name , I expect the Dept. Cost Centre textbox to update immediately, but of course it doesn't with no error, and I am lost ??
(combo18) Row Source:
SELECT DropDownListsTbl.Code, DropDownListsTbl.Group, DropDownListsTbl.Description FROM DropDownListsTbl WHERE (((DropDownListsTbl.Group)="DEPT")) ORDER BY DropDownListsTbl.Code;
(combo18) After Update Event:
Me.Text33 = Me.Combo18.Column(3)
I have a bound Department Name combo box (Combo18) and unbound Dept. Cost Centre textbox (Text33).
When I choose a Department Name , I expect the Dept. Cost Centre textbox to update immediately, but of course it doesn't with no error, and I am lost ??
(combo18) Row Source:
SELECT DropDownListsTbl.Code, DropDownListsTbl.Group, DropDownListsTbl.Description FROM DropDownListsTbl WHERE (((DropDownListsTbl.Group)="DEPT")) ORDER BY DropDownListsTbl.Code;
(combo18) After Update Event:
Me.Text33 = Me.Combo18.Column(3)