Update Table

[jschlapi]

Hello, I have a simple form with 3 buttons called RODDINGS - EXCAVATIONS - TELEVISING - WARRANTY. When pushed, the buttons open another form for additional data entry information.

I would like my table (called MAIN) to have the field (called TYPE) be updated depending upon whatever button is clicked. My main table has an AutoNumber ID.

I can get the field updated, but it updates in a separate row - it does not stay in the same row as the rest of the data. Does anyone know how I get it to stay in the same row?

Example: when I push RODDINGS, my Rodding Form opens and I can input customer name, address, fee, etc. all in row 1 and for some reason my TYPE field ends up in row 2. I used this SQL code on CLICK: INSERT INTO Main(Type) VALUES ('Rodding');


Thank you

[pbaldy]

As the SQL implies, that "inserts" a new record (an update query would edit an existing record). If it's on the form, why not

Me.[Type] = "Rodding"

[jschlapi]

Is there a special way I need to indicate table name and field name? I tried Me.Main[Type]="Rodding and also enclosed all in brackets.

[jschlapi]

YAY!! I think I got it - thank you so much for your help!

[pbaldy]

Happy to help!