Edit and Delete Records

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chinny03 - 04 Jun 2007 20:58 GMT

I am having trouble editing and deleting records. Right now all the database
has a feature where I can add records. I want to edit records by having the
user search by the primary key. Once they find the primary key the rest of
the record pops up and from there they can edit the data. For the delete
feature, I want the user to find the record just like they did for the edit
feature but when the record comes up there is a button that says "Delete
Record". They would click that button to delete the record.

Reply to this Message

Perry - 05 Jun 2007 00:22 GMT

If you're in a form presenting the record, go:
in below sequence the code to mybutton control on yr form whereby
ID is the control pointing the ID value in table MyTable...

private mybutton_click()
Dim ssql as string
ssql = "delete from MyTable where MyID" & me.ID
currentdb.execute ssql
end sub

--
Krgrds,
Perry

System:
Vista/Office Ultimate
VS2005/VSTO2005 SE

>I am having trouble editing and deleting records. Right now all the
>database
[quoted text clipped - 7 lines]
> feature but when the record comes up there is a button that says "Delete
> Record". They would click that button to delete the record.

Reply to this Message