2 Combo Boxs on form

[Shirley]

Using Access 2k

I have 2 unbound combo-boxes on a form, Combo1 lists all
InvoiceNumbers, Combo 2 lists all the Product Codes for each Invoice.
I have the 2nd combo limited to only the Product Codes for the Invoice
that is selected.

My problem is there are several other fields on the form some already
populated, others that need to be completed manually. If someone
makes a selection in both combo's how do I get the rest of the fields
(that are all in the same table) to show so that they can be edited.

I have tried to do this myself, but the Invoice Number kept changing
in combo1 when a selection was made in combo2.

Any ideas how I can make this work would be appreciated.

Thanks

 

[Marshall Barton]

Using Access 2k

I have 2 unbound combo-boxes on a form, Combo1 lists all
InvoiceNumbers, Combo 2 lists all the Product Codes for each Invoice.
I have the 2nd combo limited to only the Product Codes for the Invoice
that is selected.

My problem is there are several other fields on the form some already
populated, others that need to be completed manually. If someone
makes a selection in both combo's how do I get the rest of the fields
(that are all in the same table) to show so that they can be edited.

I have tried to do this myself, but the Invoice Number kept changing
in combo1 when a selection was made in combo2.

I think you want to use a bound subform for the editable
data. Since it's in the same table as the second combo
box's RowSource, you can use the combo box's BoundColumn to
hold the PK field for the invoice details (how depends on
how your tables are related).

The subform control's LinkMaster property can be set to both
combo box controls to get the subform to display the related
data.