can LOOKUP in form find record from *[string]*??? (1 Viewer)

[thedart]

What do I do to be able to enter characters from the middle of a record string and have the look up function find and or suggest the record?

Example: The record is "#1054 Baptist Hospital"

The LOOKUP function will only work if you enter "#1054" and then it will suggest "#1054 Baptist".

But I want to be able to enter "Baptist" and have it find the record. In other words, I want to be able to enter "Baptist" and have it find the first 5 characters which are the customer number.

 

[Matthew Snook]

See the other recent discussion: http://www.access-programmers.co.uk/ubb/Forum4/HTML/003064.html

I think it's what you're looking for...

Matt