D
Dale
I have done this before but somehow I have forgot a step or something. What I
want is to be able to have a drop down where a person can select an ID# and
then that data along with other data related to the ID and fields on my form
are automatically populated with the information. ie... ID#, First Name, Last
Name, Address. I have a database that has several tables in it. Basically I
have created a blank table that will store the responses given on the form. I
have a query setup that displays all of the information from the various
tables in one simple query. I created a form called form1 which is linked to
the currently blank table that will store the data. In that main form I have
created a subform which is linked to the query. I thought I should be able to
create a combo box and point to the query to get the data and where it ask
where to store the data I would tell it the field I needed it stored at. For
some reason this is not working. When I open up the form I have the drop down
where I can type or select the ID. Towards the bottom of the form where the
subform is, it does not update any of the fields when I select the ID from
above. Where did I go wrong?
Thanks,
Dale
want is to be able to have a drop down where a person can select an ID# and
then that data along with other data related to the ID and fields on my form
are automatically populated with the information. ie... ID#, First Name, Last
Name, Address. I have a database that has several tables in it. Basically I
have created a blank table that will store the responses given on the form. I
have a query setup that displays all of the information from the various
tables in one simple query. I created a form called form1 which is linked to
the currently blank table that will store the data. In that main form I have
created a subform which is linked to the query. I thought I should be able to
create a combo box and point to the query to get the data and where it ask
where to store the data I would tell it the field I needed it stored at. For
some reason this is not working. When I open up the form I have the drop down
where I can type or select the ID. Towards the bottom of the form where the
subform is, it does not update any of the fields when I select the ID from
above. Where did I go wrong?
Thanks,
Dale