Display Table records with vba

rwahdan

New member
Local time
Today, 12:24
Joined
Feb 11, 2006
Messages
9
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.
 
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
 

Users who are viewing this thread

Back
Top Bottom