Form fields locked in filter mode

[Guest]

Hi,
I have a form which contains fields with formulas/logic and therefore are
protected from any update by the user. However the user should be able to
enter search criteria in those same fields when applying a filter. And I'm
currently unable to make it happen...the fields are locked even in filter
mode... Any suggestion please?
Thanks a lot,
Kanga

 

[Guest]

Have two sets of controls:

1. A set of unbound text/combo boxes in the form header that allows the user
to enter information that will be used to filter.
2. Bound & locked/disabled controls to display the filtered results.

You will need to either re-create/apply the filter in the AfterUpdate of
each header control or build the filter into the form's RecordSource (e.g.
....WHERE CustomerID = [Forms]![MyForm]![CustomerFilterBox] and do Me.Requery
after updating any of the filter fields.