filter is not working

[Guest]

i have a form based on a query and i have created a combo box in order to
apply a filter on the form.
in the afterupdate property of the combo box i have assigned a macro with an
apply filter action and condition: [fieldname]=[Forms]![formname]![comboname].
but when i make the desired selection from the combo box i get no data!
moreover if i want to apply a filter should the form's properties regarding
allowing deletions, edits, etc, be positive?

thank you in advance for your help!

 

[Guest]

This would be my method of choice:

You can have the criteria of the query point to the combo box on the form
(ie [form name]![field name] ), then create a macro to Requery and apply it
to the on Change event of the combo box,

Katherine Davison
www.KatherineDavison.co.uk
Training Consultant