Display Table records with vba

[rwahdan]

Hi,

Is there away to display all records from Table inside forms using vba? I need to list all records and next each record I need two Buttons to Edit and Delete that specific record!

Please guide me or show me link for tutorials on that.

 

[isladogs]

The easiest way of doing this is to use a subform - either continuous or datasheet view.
Set shortcut menu =Yes (for right click context menu) and record selectors = Yes (small grey box to left of each record
Also set Allow Edits = Yes & Allow Deletions = Yes

Unless the subform is read only, you can just click on a record to edit it
In datasheet view, right click on the record you want to delete and click delete record

For continuous forms, right click & then select Cut.

Or for continuous forms ONLY, you can add a button next to each record and add code to delete the record. Add one button to the detail section in design view