Thanks, Albert. I'll have to investigate further but my first attempt at that gave me an error about the dataset not being in enter or edit mode.
Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBG7-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 30, 2004 7:19 PM Subject: [RBG7-L] - Re: Using Insert to add a null row > INSERT INTO <TempTable> (somecol other than autonumber) + > VALUES (NULL) > > > --- Alastair Burr <[EMAIL PROTECTED]> wrote: > > > I have a form with a temp table that I want to start with 1 row displayed ready to accept data. > > > > I can create the table and add an AutoNum as I want but how do I use Insert to prime the table > > with other null values for the row? > > > > I want to do something like: > > > > INSERT INTO Temp_Table (AutoNum_Col) + > > VALUES ( [first autonumber] ) > > > > Thanks in advance for any help, > > Regards, > > Alastair. > > > > ---------------------------------- > > A D B Burr, > > St. Albans, UK. > > ---------------------------------- > > [EMAIL PROTECTED] > > ---------------------------------- > > > ===== > 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] >
