Steven_Bash
Registered User.
- Local time
- Yesterday, 20:37
- Joined
- May 9, 2018
- Messages
- 27
Hello!
So I have this form. You can search records and this one btn is to delete it. the recordsource of where it searches records is "FULLOG". I have vba where once you click the delete btn. I have DoCmd.RunCommand acCmdDeleteRecord and it deletes it off the recordsource table(yay). But I want it to delete that same record from another table("Table2") that has that same record.
How can i do that? Ive tried CurrentDb.Execute "delete * from Table2 where VariableName =" & Me.VariableName but it hasn't worked. Thanks
So I have this form. You can search records and this one btn is to delete it. the recordsource of where it searches records is "FULLOG". I have vba where once you click the delete btn. I have DoCmd.RunCommand acCmdDeleteRecord and it deletes it off the recordsource table(yay). But I want it to delete that same record from another table("Table2") that has that same record.
How can i do that? Ive tried CurrentDb.Execute "delete * from Table2 where VariableName =" & Me.VariableName but it hasn't worked. Thanks