T
TheFayntofHearts
Hey everyone,
I'm working on a database right now, and need to figure out how to
make a combo box in a subform dependent on the combo box in my main
form. My main form is based on a table which contains a university's
FICE code (a unique six-digit identifier), the university's name, and
some numbers relating to data submissions they have made. My subform
is linked to my main form by FICE code (one-to-many), and will be used
to enter information regarding contacts made with universities: name
of the contact, the outcome of the contact, and the date and time of
the contact (this information will be stored in a separate table, and
the subform will be used to enter this information into that table).
I currently have an unbound combo box in the main form which I am
using to select the university I'm working with. What I would like is
for the unbound combo box in the subform to display the contacts from
a third table, which is also linked to the main form's table by FICE
Code in a one-to-many relationship, and have these contacts filtered
by the FICE Code listed in the main form's combo box. Any suggestions?
Thanks!
Jon
I'm working on a database right now, and need to figure out how to
make a combo box in a subform dependent on the combo box in my main
form. My main form is based on a table which contains a university's
FICE code (a unique six-digit identifier), the university's name, and
some numbers relating to data submissions they have made. My subform
is linked to my main form by FICE code (one-to-many), and will be used
to enter information regarding contacts made with universities: name
of the contact, the outcome of the contact, and the date and time of
the contact (this information will be stored in a separate table, and
the subform will be used to enter this information into that table).
I currently have an unbound combo box in the main form which I am
using to select the university I'm working with. What I would like is
for the unbound combo box in the subform to display the contacts from
a third table, which is also linked to the main form's table by FICE
Code in a one-to-many relationship, and have these contacts filtered
by the FICE Code listed in the main form's combo box. Any suggestions?
Thanks!
Jon