How to Delete Subform Record? (1 Viewer)

[adeem]

How to Delete current record in a subform using a command button? When i try to delete any record its only delete from main form ,its record does not delete from linked form.

Please Help me out to resolve this issue.

Thanks
Adeem

 

[JHB]

[FONT=&quot]Try look at the [/FONT][FONT=&quot]referential integrity [/FONT][FONT=&quot]between the tables..[/FONT]

 

[adeem]

Thanks for your reply! i am a new comer in access i don't know much about it , i have Google out that mostly peoples suggested blow coding .

Dim strSQL As String

strSQL = "DELETE * FROM table WHERE PK = " & Me.controlname & ";"
CurrentDB.Execute strSQL
Me.subformname.Form.Requery

But i am confused to understand it ,i am also going to attach an image of my form and tables detail if you can help me out accordingly or suggest me a better way to resolve this issue.

Thanks
Adeem

 

[JHB]

Try Google for "relation+ms-access", it will give you some idea how your tables should be linked together.

 

[rodmc]

Like JHB says, you need to understand the relations between your tables and be 110% sure you want to delete that record before doing it.
I delete very few records from any of my access databases.
If you are determined to delete a record from the subform you need to bring up the relationships window, identify the link between your form and subform and look for it in the relationships window, when you have done this, click on the link and select the appropriate check box, ie cascade deleted records.

 

[Solo712]

Thanks for your reply! i am a new comer in access i don't know much about it , i have Google out that mostly peoples suggested blow coding .

Dim strSQL As String

strSQL = "DELETE * FROM table WHERE PK = " & Me.controlname & ";"
CurrentDB.Execute strSQL
Me.subformname.Form.Requery

But i am confused to understand it ,i am also going to attach an image of my form and tables detail if you can help me out accordingly or suggest me a better way to resolve this issue.

Thanks
Adeem

Basically, the SQL command says: "delete everything from table called 'table' if a value of a field called 'PK' equals the control name. "

So, for example, if 'Me.controlname' field is 'Last Name' and holds the name of 'Smith' you would be deleting all the records with the last name 'Smith'. .....just saying, so you are aware.

Best,
Jiri

 

[adeem]

Thank you all who help me to resolve this issue............I Google out Relationship and my problem has been solved.

Thanks
Adeem