Delete a child recordset froma a multitable form.

C

Chieko Kuroda

Hello Everyone
Thanks for all of the help that all of you provide. It has saved endless hours of searching the web for information
I have been trying to think of a way to use a command button on a form that contains fields from three tables to delete a child recordset but the only thing that I came up with is sql language that goes something like this
Delete dbo_picuadmission
where PAdmitID = Me.PAdmitI
Does MS Access provide an automated method for deleting child recordsets in a form
Thanks again
Chieko
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Q: Automate the creation of localizable forms 1
Multiple child-record search form? 0
Blank results when using filter short-cut 0
Opening form causes Access to Freeze/Crash 4
Access 2007 "no current record" on split form 1
How programmatically Delete all records in a subform 3
Recordset for Form with a subform 5
Delete record on a parent child form 7

Top