ComboBox on a SubForm

[The Professor]

Hi



I have a combo box on a subform. From the cmbox (which was contructed with the Wizard) I can choose the Invoice Number from the dropdown list, which is then displayed in the cmbox, which is set to find the record for the Invoice Number picked. However the subform doesn't goto that Record. Yes, the cmbox displays the chosen Invoice Number, but the record doesn't change and all the information in the sunform remains as before.

I'm a little baffled, because I have a similar cmbox on the Parent Form for picking the CustID, and this works a treat. I therefore assume my problem with the Invoice Number cmbox is related to it being on a subForm. How can I get the subform to jump to said record? Can anyone shed any light?

Thanks,
Prof.

[Missinglinq]

The Subform Combobox will only navigate to the Subform Record if that Record is related to the Current Record in the Main Form; is that the situation, here? In other words, you can change the Record on the Main Form, and the Subform Records will change, accordingly, but you cannot do the reverse, with Wizard generated code. You cannot change the Subform Record and have the Main Form Record change, accordingly, which sounds like what you're trying to accomplish, here. To do this would require custom code, I believe.

Linq ;0)>

[The Professor]

Hi Linq,

Yes, that's what I'm trying to do. The two tables (Customers & Invoice) are linked (one to many) via the CustID field. However, the Subform (Invoice table) has its own unique key field - InvoiceNumber. I'm trying (and failing) to change the Subform Record and via the invoice number (via a combo box) and thereby also change the Main Form Record, if required. Like you say, this doesn't seem possible with the limited power of the Wizard. Any idea where I might get a heads up on what is needed (code wise) to accomplish this?

Regards,
Prof.