I am sooo over my head!

[Teed]

I have what seems like a very basic database begun for keeping track of clients for a social service non profit. I have set up a client form and set the client number to be unique and automatically assigned. One of the fields is for a social security number which of course is unique. What I would like to be able to do is when I go to a new record and enter an social security number that already exists in the database to be taken to that existing client's record rather than continuing in the new record. There must be a way for me to do this without doing a query to find this out. I hope I am making some sense. Can anyone help?

 

[-ian-]

I'm afraid you'll HAVE to do some kind of query here, to check if that security number already exists.

The way I would tackle it is to put in some BeforeUpdate event code on the textbox. This code would search through the database and see if that Social Security number exists.

If the number exists, it would open the relevent form at that entry.

Start just by seeing if you can get some beforeupdate code working to put up a textbox. Once that is working, you should be ready for trying some code for the query.

Best of Luck,
Ian./