Parameterised combo box on subform

[andygp40]

I have a combo box on a subform that is based on a parameterised query. The parameter is passed from the main form.

The combo box populates initially but doesn't repopulate to reflect the change of parameter on the main form.

I have tried to Requery on Enter but get hit with a "You can't use the ApplyFilter action on this window" message. That's the extent of my knowledge. Stuck. (I've obviously bitten off far more than I can chew - trying to produce membership database for local youth club - couldn't convince them that CICS/COBOL experience from 20 yrs ago was irrelevant).

All help and advice greatly appreciated. Thanks.

 

[Ramrod]

On your main form, try using the 'afterupdate' event on the field where you change your paramenter to do your requery.

 

[andygp40]

Thanks for this. Think we've cracked it though- see "please put me out of my misery" thread for details.