Connect combo box with other fields of the same table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a form i would like the user to choose the id from a combo box, see the
name in a field and change the other fields. But when i select an ID from
combobox i dont see the record of this combobox in the form. I mean tha if i
have these record ID:1 Name:OP 1st:0 2nd:13rd:2 4rth:0, when i choose from
combo box the id 1, in the other fields i didnt see the other info, I see
only what i have write. How can i see the other info, when i select a value
from the combo box?
 
A straight combo will only ever show, aside from when you're making a choice
from it, a single value.

A few ways to get the effect you're after...

Use a listbox instead.
Use a subform instead.
Use me.comboControlName.column(i) to populate other controls in the
afterupdate event of the combo. (..where i is a zero based integer to pick
out different column values...)

Which one you use is down to what effect you're after.
 
Look first for your help. Then, I find in the wizard of combo box a third
selection which says: "Find ....".But this selectio doesnt appear any time
....:(
The problem has another base now.
My form has this struct:
A combo box with Lessons_ID
A combo box with Stud_ID
A box with Stud Name
and three other boxes which the user can write the exam degree.
When i create the form when i choose the Stud ID the degree fields and the
name field appear data.Now I connect the como box of Stud_ID with the Lesson
ID to limit the data of Stud_ID combo box. I success to limit the data of
Stud_ID combo box but now when i choose a Stud ID i cant see the name and the
degree.WHats up? What can I do?
 
If your Stud_ID combo has multiple columns... let's suppose the ID in the
first column (i.e. column number 0) and the student name in the second (i.e.
column number 1) then you could set up another unbound text box (call it
txtStName for example). Then, in the after update event of the Stud_ID
control you can just do

me.txtStName=me.stud_id.column(1)

Does that not work?
 
Back
Top