Yes - when I have all of my lookup tables (for classification codes) using an integer for the Unique ID and the combo box showing the name, and converting old system data to have the unique id of -1 ...
it messes up what I had planned for my application ...
-1 = old system classification
0 = user not selected classification
1 to
= new system classification
I will have to forgo the use of -1 instead or redesigning ALL of my tables, especially since integers take up only 4 bytes versus a character field of 10 bytes.
But that's my kettle of fish to fry <g>.
James
>>Oh - well - that messes up what I had planned (-1 for old system converted lookup code).
>
> Not really. as I said before, if you remove step # 3, it will work just
> fine. You will just have to VAL() the value of the textbox.
=======================
J Robert Jernigan
Calabasas, CA USA
jrjernigan@hotmail.com"To err is human ... I should know, I get to show my humanity everyday!" jrj
"I just love the internet - it takes this great big planet and makes it smaller. Now, why can't we all just get along?" jrj