Delete Records

[Kila]

I have a survey form that has the questions on a subform based on the response to one of the survey demographic questions (via a query based on that response). The answers to the questions are on a sub-sub form. How can I get the program to delete the answers that were entered (they are related to the primary survey form with a common ID number) if the user changes the survey response.

In other words, if the user of SurveyID 5 decides that they want to fill out the list of blue questions rather than red questions, how can I delete all the answer blue records for SurveyID 5? Right now, it will display the red questions if you change to red and enter red answers, but the blue answers remain in the database, creating 2 sets of answers for SurveyID 5.

Any suggestions...if this is not too confusing?
Thanks!

 

[llkhoutx]

It's not clear to me in you posting where the red / blue indcator(s) are or which form has the records to be deleted or where the crieria is stored. However, on the red / blue indicator(s) AfterUpdate event, delete the requisite records from the appropriate table and requery the form, sub form or sub sub form on which they were displayed.