delete ith DLookup 1

[peljo]

I have a form with not updatable controls. Can i however delete rows in the table referring to the control clicked on the form ? For example, in my form i have a productid = 76. Could i clicking this control delete the productid = 76 from the table products1 ?

 

[Remou]

You can set AllowDeletes without AllowEdits or you can run a query through vba. I guess you are refering to a continuous form and a control at the end of each line? If so:

strSQL="Delete From tblTable Where NumericID=" & Me.txtNumericID
CurrentDB.Execute strSQL, dbFailOnError

 

[GingerR]

You could put a button on the form, and OnClick run the code Remou has above. Then I'd REQUERY or else it shows up #DELETED in each field.

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[peljo]

Thank you so much ! It works