Can i have a box in a form, which - when you select specific data from the list, it will update a number of other textboxes which will show the data conected to the first piece.
E.g,
If i can choose a number of staff ID's from a list.
And when the ID number has been chosen, the staff details will appear in the other text boxes.
2007-03-20 07:27:39 · 2 answers · asked by Gurpz 2 in Computers & Internet ➔ Programming & Design
Yes, and it is simple.
On the list/combo box set that the values come from a query with multiple columns. Bind first column in the list (Bound Column = 0). You may display one or more columns in the list, does not matter.
Lets say the combo box is named Field1 (best that it matches actual field name).
Bind other text boxes so to show value of other columns in the selected row, e.g.
For text box #1 set "Control Source" to "= [Field1].Column(1)", for text box #2 set "Control Source" to "= [Field1].Column(2)", etc. Don't type quotes, but the equal sign is a must.
2007-03-20 07:34:35 · answer #1 · answered by BataV 3 · 0⤊ 0⤋
The record is propietary ergo i think of you could in effortless terms run it utilising MS get admission to. you could besides the shown fact that browse it and edit it with a application referred to as "MDB Browser", google that. you additionally can link to and question the preparation provided you have the perfect drivers put in.
2016-10-02 11:12:36 · answer #2 · answered by ? 3 · 0⤊ 0⤋