Hi Tom,
If you want to add an ID number, I'd do it different way. If this table is a part of DataBase, you can use default() value and assign GetNextID() to it. Thre were lots of threads devoted this problem, see Craig Berntson article in his knowledge base.
I love Boston and was in Symphony next Thursday. It was Mahler 2nd symphony and there are not enough words to describe my impression. It was one of the best perfomances I either heard. Marvellous!
>Hi Nadya, and Thanks.
>
>This is kind of what I thought I would have to do I was just unsure about placing the code before or after the dodefault.
>
>What I need to do is really quite simple. I need to add an id number (that links this back to another table) and I do not want the user to have a chance to enter the wrong number so this form leaves that field out.
>
>I have a sister that lives in Boston... hope you love it as much as she does. At least you have a great symphony!
>
>Tom Gahagan
If it's not broken, fix it until it is.
My Blog