Deleing fields in a subform

[Guest]

I have a form (Insurance Companies) and a subform (Insurance Company
Contacts). The subform has many contacts. I am trying to create a button in
my Insurance Companies form that will delete the current field in the
subform. Any suggestions?

 

[Stefan Hoffmann]

hi,

I have a form (Insurance Companies) and a subform (Insurance Company
Contacts). The subform has many contacts. I am trying to create a button in
my Insurance Companies form that will delete the current field in the
subform. Any suggestions?

If you want to delete the current record (dataset) in your subform, then
the following should work:

Private Sub cmdDeleteContact_Click()

CurrentDb.Execute "DELETE FROM Contacts WHERE ID = " & _
sfInsuranceCompanyContacts.Form![ID]
sfInsuranceCompanyContacts.Form.Requery

End Sub

If you don't have an unique identifier, you need to change the condition
to match the primary key fields in your contacts table.


mfG
--> stefan <--

 

[Guest]

Correction, that should be deleting records in a subform. I want to be able
to delete a contact at the click of the button.

 

[John Vinson]

I have a form (Insurance Companies) and a subform (Insurance Company
Contacts). The subform has many contacts. I am trying to create a button in
my Insurance Companies form that will delete the current field in the
subform. Any suggestions?

Use the Command Button tool on the toolbox, with the magic wand icon
selected. Choose the option to create a button which deletes a record.
It's simplest if the button is *on the subform*, rather than on the
mainform; when a command button has the focus on the mainform, it's
ambiguous WHICH record on the subform you mean.


John W. Vinson[MVP]