I have created a form based on a table that includes fields:

Home Model Names
Framing Dollar Amount
Hanging Number of Boards
Hanging Price Per Board
Hanging Dollar Amount (which could be a calculated field)

After the model is selected, I want the end user to have the numbers for each of the fields populated in the fields listed above (and some others as well) so there is no duplication of data entry for them. It seems I could use After Update on the Home Model combo box, but I am not sure of the syntax to use to bring in the information for the various fields. I am relatively new at Access, so your patience is certainly appreciated.

I have been unable to figure out how to filter the fields so that it populates the fields for the specific home model selected. Thanks very much for your assistance.