Auto populate form field based on selection

[Richnep]

Hi,

I have a form which is linked to a table(tblAntibody) for data entry.
I have another table(tblCatalogPartNumbers) with no relationship to
the first which contains all of our codes and has four coulmns
CatalogNumber, UnqualifiedNumber,NIPartNumber, and PIPartNumber. All
of these columns store thier data in tblAntibody.



On the form CatalogNumber is a combo box that has it's selection
criterial set to tblListCatalogPartNumbers. What I need to happen is
when a user selects a catalog number from the combo box, I need the
other 3 fields to auto populate from tblCatalogPartNumbers.
CatalogNumber is the primary key in tblCatalogPartNumbers.

Any help would be appreciated.

 

[SteveD]

I'm sure there are other ways, but one is to have a query that is the
recordsource for the form, which uses the combo box as the criteria for the
CatalogNumber. In the AfterUpdate event of the combo box, place a me.requery
This will requery the form when something is selected in the combobox.

Hope that helps,
SteveD