Filter on form button, and report query

[mattkbishop]

Filter on form button HELP !!!! :-(

1) Ok well I like this filter on form button... but.... is there any way I can get it assigned to a button on the form, and then another button to select the filter (when all the other existing buttons are faded out)?

----------
2) Also, how do I create a report to pull off all of the records that are FILTERED.

So I got 100 records, filter them, hit a button, report is printed showing only each record once (ie, their RecordID is allowed once, so I don't get duplicates due to subforms). How do I do that please?

 

[Hayley Baxter]

Using the cmdbutton wizard select Form Operations and Apply Form Filter.

There is an option to create an AutoReport on filtered records under the new object icon.

Hay

 

[mattkbishop]

Using the cmdbutton wizard select Form Operations and Apply Form Filter.

That only applies the last selected filter, it won't let you edit the variables to filter on, like the Filter by Form button does.

There is an option to create an AutoReport on filtered records under the new object icon.

This is the bigger prob I am having... the report must be customized - ie. Has to look how my boss wants it. And I got no clue about a new object icon, sorry, I'm not very advanced with access.

 

[Hayley Baxter]

Ok I use something similar which works for me so if you like you can send me the form you are working with with an explanation of what you need to filter and I'll see what I can get working for you.

Hay

 

[mattkbishop]

Thanks Hayley but I've sorted it now.

I got a friend to help - basically, we opened another form and ran the filter form command (using DoCmd.) at the same time.

On the pop up form, we had the filter form controls - such as run it, clear it, exit and restore etc.


Thanks anyways though.

 

[mattkbishop]

Ok well I got the filter on form thing working, but I have a problem...

When I'm selecting data to search on in the filter on form mode, I can't select a few fields.

The reason for this, is because in normal form view, the fields (one subform based on a tick box, and two tick boxes based on another tick box) are invisible and only shown when it's representative box is ticked.

I hope that makes sense.

Anyways, in filter by form view, these (the subform and tick boxes) remain invisible, even if the boxes they are dependent on being shown are ticked.

So how do I get all my fields/subforms visible in filter by form view?