Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Delete record by using VBA Coding

Status
Not open for further replies.
kasmawati

kasmawati

Programmer
Feb 10, 2003
1
MY
How to delete a row of data in a subform by using VBA Coding
 
Sort by date Sort by votes
Hallo,

You can either use
OpenRecordset, and the delete method,
or
docmd.RunSQL "DELETE * FROM [tbl] WHERE [field]=criteria

- Frink
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Moss100
  • Locked
  • Question
Filter vba problem
Replies
1
Views
567
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
390
TheAceMan1
TheAceMan1
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
513
Andrzejek
Andrzejek
Knicks
  • Locked
  • Question
Microsoft Access VBA Coding to Excel (early binding) 1
Replies
2
Views
834
Knicks
Knicks
Kennelbloke
  • Locked
  • Solved
Refer to Navigation Control Subform Record
Replies
8
Views
793
Kennelbloke
Kennelbloke

Part and Inventory Search

Sponsor

Back
Top