select 2 combo boxes to fill other text boxes

[Jim]

Hi, there,

I am a beginner on Access.

I have been taking so long time to try to figure out his, but so far,
no clues.
I want to select 2 combo boxes and Access will automatically fill in
other 5 bound text fields for me. I searched all groups and microsoft
support sites, no result.

The 1st combo is "Capacity", the 2nd combo is "Door", I want to change
2 combo boxes with different selections, the 5 text boxes value will
be changed accordingly. The form is based on a query which combine 2
tables together. That is, I can not change the form's source to
another query.

Anybody can help me to figure out how can I make this happen, no
matter VB or SQL or query method? Thank you in advance.

Jim