How would I?... in a form

[bbcwjun]

How can I in a form field, after I enter data (ie. phone #) to automatically look up in a query or table to match the exact ENTIRE RECORD to that data I entered? Do I build an expression or run a macro??

Thanks!

 

[Robbo1974]

It's a bit simpler to just filter by form (assuming that all you are trying to do is find a record, not append a new record with exactly the same information). Robbo ;-)

 

[bbcwjun]

How do I solve this problem with filtering then? If I filter and it doesn't find a matching record it displays a blank record (filtered).. how can I make it go back to the form field with a displayed message like "not found"?

THANKS!

 

[Robbo1974]

In this case I would use the 'find' function. If you're restricting menus launch it from a command button (code 'DoCmd.RunCommand acCmdFind' in the button's on click event). This should do exactly what you want, but you will have to type the value you are looking for in.

I know that it's not exactly what you're trying to achieve but it does work and very well too. In my book, simplicity is king! Robbo ;-)