Deleteing rows

[kicken18]

I am developing a database for a buisness. a Customer phones up, gives the details and I pick the details from a drop down list which is from a table.

Basically the details will be taken down, a turkey weight will be picked from the drop down list and this will then be removed form the table. (data entry is via a form obvsilly) the order also has a check box, and i want a delete query to run when this check box is ticked, which deletes the turkey (turkey ID, turkey weight) which has been placed in the order

i hope someone can understand this i am quite stuck

Thanks
Chris

 

[kicken18]

no one got any ideas?

 

[gecko_1]

sSql = "DELETE FROM turkeyTable WHERE turkeyID = '" & cboBox.column(2) & "';"
currentdb.execute sSql

Is this what you are looking for, cboBox.column(2) would need to relate to a turkeyID.

Todd

 

[kicken18]

well i understand the first bit, and i understand the bit of where turkey ID = from my sue of SQL with PHP but i am unsure of this bit "" & cboBox.column(2) & "';"
currentdb.execute sSql" im guessing the second bit is easy but the fist bit...what is column(2) about?

Thanks