update subform from combo selection

[christheancient]

I've been through the search and can't quite find a match for what I want.

Working on A97.

Two tables. The main table is tblCustomerDetails and a lesser table tblTariffs.

I have created the forms for the two tables as frmCustomerDetails and frmSubTariffs.

In the main form frmCustomerDetails, I have a combo to call up the 'main' fields of the tblTariffs and the frmSubTariffs.

When I re-open the main form every time, the frmSubTariffs shows the correct info...

But, I can't seem to find the syntax for AfterUpdate on the combo that will actually update the subform while everythings open!

I bet it's dead simple. But I'm even simpler! What's the syntax I need, please?

TIA

Chris

 

[bjackson]

in the after update event for your combo

me![yoursubformname].requery

 

[christheancient]

Hi BJ

Have tried that - but it is less than efficient in that the subform only seems to update after I leave the combo.

It would have been nice to do it as soon as a new item is selected in the combo (I tried using On Change - with no effect)

Looks as though I may be stuck at that level.

Unless anyone knows different!

Chris