filter table and open populated form or new form

[clyons]

This is what im looking to do. I have a login/home box with an unbound text box. When I enter a number I want it to search through the main table to see if this number exists, if it does I want it to open the corresponding form and autopopulate the fields, if it doesn't exist I'd just like it to open the form to create new info. Can I do this easily?

 

[jdraw]

This is what im looking to do. I have a login/home box with an unbound text box. When I enter a number I want it to search through the main table to see if this number exists, if it does I want it to open the corresponding form and autopopulate the fields, if it doesn't exist I'd just like it to open the form to create new info. Can I do this easily?

What have you tried so far?
What is your approach?

 

[clyons]

I've tried to call some basic search form functions and find records but im not sure on how to get it to differentiate between opening the new form or update form.