Edit/Delete Record in Search Form

J

Jess

Good Morning,
I have a form in a database based on an example on Allen Browne's site:
http://allenbrowne.com/ser-62.html
Which works great.
So i can search for the records, but now i want to be able to edit and/or
delete a record on the form.
So ideally i would like a user to go into the form above (on Allen's
website), search for a record, select a record from the results, the records
details be dsiplayed in the appropiate fields for editing and then have a
save and a delete button so they can either save any changes made or delete
the record if required.
Is anyone able to help me with a solution to this?
Also keep in mind that i am not code savvy at all... far from it.
thanks :)
 
A

Al Campagna

Jess,
I use something I call a jump field, so the user can "jump" to the
"full" form to edit that specific record.
Use an event, like the Double Click of the CompanyID field, and open up
the appropriate form for editing.
Using a full form named frmCompany... (use your own names)
Private Sub CompanyID_DblClick(Cancel As Integer)
Docmd.OpenForm "frmCompany" , , , "CompanyID = " & CompanyID
End Sub
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top