stLinkCriteria with similar fields

[Nick Hampu]

I'm trying to open formB with a command button from formA. The linking criteria is [PartNumber]. The problem is, there are instances where the part number has the suffix "OE". Most of the time, the part numbers will be identical, "1234-123" = "1234-123. Occationally, I'll need 1234-123OE to find "1234-123".

Thanks in advance

NH

 

[Ziggy]

If your field length from left to right is standard (same length) except for the 2 extra characters, try making a query with that part field in an expression like this:

Part1:Left([part],8)


That will return the matching value to the field, now you modify your set up to use the query instead of the table and reference the new field instead. I just had to do the exact thing for one of my reports.