I have followed this video: http://datapigtechnologies.com/flash...tomfilter.html . It worked good. So, we entered data. Now we have about 400 data entries and I noticed a problem. When I type 23 it wants to bring up 230 and I can't get it to allow me to type in only 23. I have checked my data. The numbers are the record ID and are the primary key. So, what will happen is when I get to th 1000's of entries then I will only be able to bring up those records and not the three digit entries. Does this make sense. I don't know how Access can make this mistake. I have double checked my code with the video and everything is the same. And it seems that this is the only way it works. If you can help please do. I will check back to see if no one can comprehend.
Thanks,
Lowell