requery in subform

  • Thread starter Thread starter Dimitris Nikolakakis
  • Start date Start date
D

Dimitris Nikolakakis

I have a form FOrders and a subform FOrdersTx
In the form I have the field FactoryID

In the subform I have a field StorageCode (combo box) that takes data from
storage with selection qry
SELECT Code from Storage WHERE Storage.FactoryID =
Forms![FOrders].FactoryID

I also have a combo box Description that works like StorageCode combobox

My problem is when I change the Factory in main form the requery is not done
in the two combo boxes

I have tried in AfterUpdate of FactoryID:
Forms![FOrdersTx].Combo6.Requery
Forms![FOrdersTx].Combo8.Requery

but it does not work

thanks in advance
Dimitris
 
If your combobox is called StorageCode, why are you calling Combo6 or
Combo8.Requery ?

Try this in the AfterUpdate event of FactoryID

Me.[FOrdersTx].Form.StorageCode.Requery
 
Back
Top