H
hkgary33 via AccessMonster.com
Hi all,
I've built a table named STU_DATA which stored student name and it's ID, it's
design is as follows:
STU_NAME ID
David 1234
John 1235
.....
I've also built a form to let user choose STU_NAME by pull-down combo box,
and a text box for user to input the student ID.....what I would like to ask
is that how can I amend in the form control so that each time when the user
choose STU_NAME in the combo box (which will then display all STU_NAME fields
in the STU_DATA table to let user choose), then the ID text-box will
automatically search that student's name in STU_DATA table and fill in that
student's ID.......
THANKS!!!!!
I've built a table named STU_DATA which stored student name and it's ID, it's
design is as follows:
STU_NAME ID
David 1234
John 1235
.....
I've also built a form to let user choose STU_NAME by pull-down combo box,
and a text box for user to input the student ID.....what I would like to ask
is that how can I amend in the form control so that each time when the user
choose STU_NAME in the combo box (which will then display all STU_NAME fields
in the STU_DATA table to let user choose), then the ID text-box will
automatically search that student's name in STU_DATA table and fill in that
student's ID.......
THANKS!!!!!