I know this can be done because I have another access based
program(that the code is protected) that does it but I can't figure out
how.
I have a table with several fields, two of them are company and
lastname. I want a to open a form that has a box LastName/Company: and
when I start typing in that box all of the matches last name and
company populate the list - so for example I type in the box brow
and the list populates
Brown Construction
Brown James
Browst Inc
etc.
I posted this before and was told to use the criteria field with Like
but it doesnt' work in the other database I have I don't have to use
wildcards I just type and it comes up.
Thanks
PS I also got the reply combine Lastname and company into one field but
I know I don't have to do this because of the other database I have and
I don't want to do this