Filter on continuous sub form

[access7]

Hello

I have a sub form (continuous form) which shows conversation logs. Fields on the form include; Date / Time / Correspondence Type / Contact Name / Created By / Created When and Notes

I have record selectors on so that the fields are searchable (i.e. if you are looking for all correspondence with 'Joe Bloggs' then you can enter 'Joe Bloggs' into the search name and each time you hit enter it takes you to his next recorded conversation. This is a great function however I have been asked to take it one stage further in making it possible to filter on 'Contact Name' so that we can see on screen conversations for just that one person (rather than having to scroll through / search for each one).

When I am in 'developer mode' then I can simply right click on a field and choose to filter e.g. 'Equals "Joe Bloggs". However once the user logs in (not in development mode) this option is disabled - as is the filter option on the record selection bar.

Can anyone give me any clues on how to enable the user to be able to use this function?

Thanks

 

[RJGoodhead]

I've not really got any experience on this but perhaps you can use the Filter property in the Data tab of the sub form's Form Properties. I was thinking it could be set to respond to an entry in a text box.
http://office.microsoft.com/en-us/access-help/filter-property-HA001232736.aspx
As I say, I have no experience with this, just noticed the option before, so no idea if it works or there is a simpler way