Do an action if item in/not in list

[Stuart Green]

I have a table with client details, each client having a unique number. I want my users to be presented with a simple input form where they type a client number in (probably use a combo box). If the number already exists then I want the user to be taken to a form to modify the details, if it isn't in the list then I want to create a new record. So ,if it's in the list then modify, if it isn't then create new. Sounds simple but it is the day after a public holiday and I am SLOW today! Any ideas would be gratefully received

 

[dcx693]

Take a look at the Developer Solutions database that ships with Access. There's an "Enter or Edit Products" form that pops up a dialog form for entering a new category.