Filtering data on one form based on another

[kesam]

I have one form which contains a seperate record for various cost codes and their meanings. I also have a separate form whose records detail those people allowed to authorise funds to certain cost codes.

On inserting a button to link the two fields(to filter and display the records of only those signatories authorised for the currently displayed cost code) everything worked fine for all except those signatories who had more than 1 cost code for which they are authorised.

In the signatory form a person can be authorised for more than 1 code ie abc3, abc4, def5 etc. whereas in the cost centre form each code is entered singularly alongside an explaination of it's meaning.

Is there a way to make the filter work in such a way that it will look for the information within the specified field but not look for an exact match. If it were to work like the "FIND" - "ANY PART OF FIELD" operation that would be ideal.

I hope that makes sense. I would appreciate any help or suggestions.

Thanks

 

[namliam]

use *a* for example this will find
Andrew
is a big
Stupida

LOL

Regards

 

[WayneRyan]

kesam,

The "Like" operator does this. See the Help files or do a Search
here on this forum.

"[SomeField] Like '*" & Me.SomeControl & "*'"

Wayne

 

[kesam]

very much a vb novice but managed to get it working with the LIKE '* command.

Thank you.