Requery Problem - Cannot Requery Combox Box on a Subform

[aamer]

I am unable to do the Requery the subform.


I need help on how to Requery the combo "TranIDCbo" on the "InvoiceSubfrm" subform

Also on the "SaleDetailByDateFrm" If The Date in "Combo121" Combo box Is Blank It Shoud Not Show Sales Details in form "SaleDetailByDateSubFrm", how can I fix that It Only Shows If Date Is Selected.

A sample DB is attached.
Sample 2 Fix.zip

[Welshgasman]

Where are you executing the code?
Forms: Refer to Form and Subform properties and controls

Re the sale form. If you add the combo as criteria in the subform recordsource query then that will happen automatically.
However better to link mainform and subform by the required fields?

FWIW developers generally do not use macros. I am not a developer and I still do not use them. VBA is far more flexible and more importatntly, easier to debug.
I'd advise you to start using VBA, plus so many more examples out there for VBA.

Also look at Youtube, plenty of videos on there to get started.