Open with a form filter

[alxj]

Hello
Is it possible to open a form and have it displayed in a blank form filter, instead of opening the form and then clicking the icon for form filter. If not does anyone know how to display the form filter button inside the form instead of being on the toolbar of access (it does not seem to appear as an option in the command button wizard?).

Thanks for all your help

Alex

 

[Ernie Taylor]

This is one I have used on a report to identify user's filter by selection choices. On the form I created a text box called totfilter and one called subfilter (this is populated by =[Filter]. The totfilter is unbound and populated by this code within the subform:
Me![totfilter] = Me![subfilter] & " AND ([wip by contract].activity='" & Forms![Contracts Summary]![contractno] & "')"

The latter part of the above collects data from the main form and adds it together with the last reference which is a call from another form (cascaded forms).

On the report I used this code(note the report is run from a button on the form so the form is still open)

Private Sub Report_Open(Cancel As Integer)
Me.Filter = Forms![WIP Cost by Contract]![WIP contract subform]![totfilter]
End Sub

I hope this helps you with the use of filters

 

[alxj]

thats very nice ernie but how does this tell me how to have the form open showing a blank form filter of the form?

 

[Ernie Taylor]

It's a workaround.By using the code or a variant you can filter the form using text boxes and vb Me.filter =....

In other words don't try to use the standard filter by form work on a filter which is selectable by the user under your control.

Alternatively create a list of text boxes and a query using the text box references as criteria.