E
Eric
I wanted a form to automatically fill in a description
field for a product when I typed in a part number in a
different field on the same form. I did everything that
Access Help told me to do to make this happen, including
creating a relationship between two tables (one that has
the descriptions of each unique part number, with the part
no. as the primary key on that table, and the table that
the form is bound to, which is the "many" side of the
relationship). Then I created a query with the "part
number" field from the "many" side of the relationship and
the description column from the "one" side of the
relationship. Apparently, that is all I would need to do,
but the form still will not automatically insert
information. Do I have to type something special in
the "control source" property of the Description field on
the form? I think the Help might be missing a step or
something.
The help files I was following are under these headings:
Create an Autolookup query
About Autolookup queries that automatically fill in data
field for a product when I typed in a part number in a
different field on the same form. I did everything that
Access Help told me to do to make this happen, including
creating a relationship between two tables (one that has
the descriptions of each unique part number, with the part
no. as the primary key on that table, and the table that
the form is bound to, which is the "many" side of the
relationship). Then I created a query with the "part
number" field from the "many" side of the relationship and
the description column from the "one" side of the
relationship. Apparently, that is all I would need to do,
but the form still will not automatically insert
information. Do I have to type something special in
the "control source" property of the Description field on
the form? I think the Help might be missing a step or
something.
The help files I was following are under these headings:
Create an Autolookup query
About Autolookup queries that automatically fill in data