How to filter on forms ?

[novoiceleft]

Hi

Can any kind person show me how to fix my problem - of how to view a filtered form based on a subform value ?

I have built a subsection of my database - attached.

I am a beginner - I cannot write code - but if some one were to fix this for me, I could transport the code or the macro into my real database.

The main form is called 'Deals'. The subform is called 'Sectors'. What I am trying to do here is use the dialogue box to input parameters of Start Date, End date, and Sector - to press the view button to display a filtered set of Deals.

I have managed it for the Dates - but I cannot do it for the Sector, either by a query, a macro, or my attempts to learn SQL.

Perhaps someone could fix this - and post it back.

By the way, the dates are in "mmm yyyy" format, so you just type in "3 2003" etc.

All help appreciated

NoVoice

 

[ssoltic]

I do something for you. If you want to filtering form, create these forms based on querys. There you can put criteria for filtering...

First you must learn naming conventions. Lots of name confusing on your prog.

Hope this help

 

[novoiceleft]

I got this working all OK - thanks for your help.

And I promise to improve my naming conventions.



NoVoiceLeft