Tom, make sure you do not have one too many items in the insert. When I write insert statements, I tend to INSERT INTO Tsble1 (C1, C2, C3, C4) + SELECT value1, value2, value3, value4 + FROM something or other OR INSERT INTO Table1 (C1, C2, C3, C4) + VALUES (.v1, .v2, .v3, .v4)
Note that in the statements the number of columns in the parentheses is exactly equal to the number of values in the INSERT or VALUES list. --- Thomas Eldred <[EMAIL PROTECTED]> wrote: > I am working to insert 2 fields into a 7 column table and then call a form > to edit the remaining information. One of the columns is autonumbered and > one is set after the command completes. > > The command file works, but the error "-ERROR- Incorrect number of values > for this table(118)" Is returned. > > Since the values are correctly inserted into my table and the form appears, > I assume that this error is only for my benefit. What would I need to enter > in order to not display this message? Or should I insert null values into > the columns in the command and then edit them in the form? > > thank you > tom > > ===== Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
