Delete all associated records

[w0od0o]

Hi all,

I am trying to create a cancel type button that will remove data that has been added so far, my problem is i have 2 queries on 1 form and i can only seem to get it to delete the records associated with the query that the cursor is in (if that makes sense)

All help welcome

w0od0o

 

[vbaInet]

You can move the cursor using a method called SetFocus.

 

[w0od0o]

so are you suggesting i move the cursor to the record holding the sub-record and this will cascade through?

so dont want to spend hours trying to figure it out

 

[vbaInet]

Are you trying to undo?

It would depend if you have set referential integrity on the joins?

 

[w0od0o]

i have set referntial integrity, but at the moment whether its undo or delete it onlt removes the data where the cursor is,

what i have is a query that Dmax's a quote number on load and i want all associated data removed if the user decides that they dont want to continue.

thanks for your help

w0od0o

 

[vbaInet]

You may need to refresh and/or requery the other form.

Did you set Cascade Delete?