W
wesley.allen
FYI: I am somewhat new to Access, so I try to do things simple using
macros rather than SQL.
That being said, I am trying to setup a form that has a combo box where
I can make a selection and have the form run that selection of a name
and have the form pass that selection to a table and if possible show
the data on the form.
Detail.
I have a form setup where I am inputing results from a survey. The
table that holds the info uses email addresses to identify the
respondants. I have another table with the respondants names and
corresponding email addresses. When I input the responses, I want to
use a combo box to select the respondant (because I don't know their
email addresses without looking in the table that has them) and have
the form automatically add their email address to the table with their
responses based on the name I select.
I know this is a bit confusing. Sorry. Any help is appreciated.
Thanks.
macros rather than SQL.
That being said, I am trying to setup a form that has a combo box where
I can make a selection and have the form run that selection of a name
and have the form pass that selection to a table and if possible show
the data on the form.
Detail.
I have a form setup where I am inputing results from a survey. The
table that holds the info uses email addresses to identify the
respondants. I have another table with the respondants names and
corresponding email addresses. When I input the responses, I want to
use a combo box to select the respondant (because I don't know their
email addresses without looking in the table that has them) and have
the form automatically add their email address to the table with their
responses based on the name I select.
I know this is a bit confusing. Sorry. Any help is appreciated.
Thanks.