update stock records?

[zambam]

hi,

i have some data in access which is linked to a vb6 form. i want to make this happen:

when the user clicks "rent", the product will be removed form the products table(to show its not in stock), but when it is brought back, it should be put back into the products table with the same product id. (the product id is auto number).

is this possible? it seems to be very simple.

pls help. thanks.

 

[DrSnuggles]

dim mstrSQL as string
mstrSQL = "DELETE * FROM [Products table name] Where [product id] = #"

Execute through connection String . .


But this will delete ALL the same products from your table.
Is this what you want?
I feel you have to extend the WHERE clause??