Dynamic Filtering on Forms

[tonygg]

Hi. I think I am missing something obvious. Hopefully someone can put me straight.



Bit of background first:

I have created a nested set of queries to sum up orders placed by products and then by product ranges. Basically I get all orders with first query and creates some calculated fields. I then summarise the results by product in another query based on the results of the first (again with some calculated fields). I do another grouping query to summarise by product line (groups of products). This all works fine and I can create a form using the third set of results (orders summarised by product line).

ISSUE: Now comes the problem. I am trying to filter the results in the continuous form. My issue is Access does not allow me create events (subs) to run the filters. If I add a command button and in add code for event "command button clicked" and then try to save the form I get the error:

~

If I take the action to set Has Module to "NO" it removes my code.

Any ideas what I am doing wrong?

many thanks

Tony

[ItsMe]

I have never seen that error before. However, I would try selecting all of the controls and then right click one of the controls. I would select Layout > Remove Layout. It seems your command button is violating some sort of Layout thing.

[tonygg]

It was layout as when I removed all it started working. Thank you

[ItsMe]

OK, great. Thanks for posting the solution here.