Continuous Form - Showing additional data

Hi,

See attached simple database.

Customers place orders for car parts!

1.  Run frmHeader which has a subform frmDetail.
2. Choose a customer from frmHeader
3. Now choose a part from frmDetail  (Important: this is a continuous form)
4. So far so good!

Requirement: In the frmDetail - note the two yellow text boxes.   How do I populate these yellow boxes with tblParts.Price and tblParts.Colour

(Obviously, the price & colour are for display only and not stored in the tblOrderDetail)
Database4.accdb
Patrick O'DeaAsked:
Who is Participating?
 
Gustav BrockConnect With a Mentor CIOCommented:
1. Change the rowsource of Combo0 to:

SELECT tblParts.CarPartID, tblParts.PartDescription, tblParts.PartPrice, tblParts.PartColour FROM tblParts;

2. Change columncount of Combo0 to 4.
3. Add two more column widths - both of 0 (zero) - to ColumnWidths of Combo0.

4. Use as ControlSource for your two yellow textboxes:

    =[Combo0].[column](2)
and
    =[Combo0].[column](3)

/gustav
0
 
Patrick O'DeaAuthor Commented:
Thanks Gustav,

Works perfectly!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.