autolookup queries

[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

 

[Eric]

Steve,

No, the Form is using a table as its record source. Can I
leave the table as a record source for the form but bind
the one field called "description" to the query?

Eric

-----Original Message-----
Eric,

The Description textbox on the form needs to be bound to the
Description field in the Query. Is this what you've got?

- Steve Schapel, Microsoft Access MVP