K
kkjd
With one master table and several smaller tables I have created a form that
uses the combo box/list box feature to look up the data for new entires in
the master table, However I am stumped how to have the fileds automatically
filled in rather than showing all the records in the smaller tables. I
expalin more further. The master table coresponds to the main form for new
data entry. In this form, I have 3 related fields that use drop down combo
boxes to fill in repetitive data. All the fields are in the master table as
well while the list of programs, advisors and courses are stored on the
smaller tables.
For example: some fields on the form include : [First name], [last name],
[PROGRAM], [season], [PROGRAM ADVISOR], [dates], and [PROGRAM COURSES]..and
so on.. Although all names are different how can I format the CAP fields
abvoe so that once I choose the [program] first from the list box, the
predetermined {advisor} and predetermined {Program courses} automatically
fill in the respected fields rather than having to scoll through them and
searching through the list of all the advisors and all the courses avaliable.
uses the combo box/list box feature to look up the data for new entires in
the master table, However I am stumped how to have the fileds automatically
filled in rather than showing all the records in the smaller tables. I
expalin more further. The master table coresponds to the main form for new
data entry. In this form, I have 3 related fields that use drop down combo
boxes to fill in repetitive data. All the fields are in the master table as
well while the list of programs, advisors and courses are stored on the
smaller tables.
For example: some fields on the form include : [First name], [last name],
[PROGRAM], [season], [PROGRAM ADVISOR], [dates], and [PROGRAM COURSES]..and
so on.. Although all names are different how can I format the CAP fields
abvoe so that once I choose the [program] first from the list box, the
predetermined {advisor} and predetermined {Program courses} automatically
fill in the respected fields rather than having to scoll through them and
searching through the list of all the advisors and all the courses avaliable.