[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

DELETING CURRENT RECORD

Hi,
      I am beginner in VBA.I have a form in MS Access.I want to delete the current record,which is being displayed, when i click the delete button in the form.But the id field of the table which is a primary key is not displayed in the form.I dont know how to give the where clause in my delete statement.
     "Delete from budget where ??????"
     Plesae clarify.

Thanks
shan
0
srshan
Asked:
srshan
1 Solution
 
funkeCommented:
on your form add a control that binds to the id field.  Set the visible property to false - you can then reference this fields value
0
 
1WilliamCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept question, points to funke
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
1William
EE Cleanup Volunteer
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now