Clearing Combo Box When Advancing to a New Record

[Uninvisible]

I have developed a survey with the following tables:

TBL_RESPONDENT
[RESP_ID]
[SURV_ID]

TBL_QUESTION
[QUESTION_ID]
[QUESTION]
[SECTION_ID]
[COMBO_ID]

TBL_RESPONSE
[RESP_ID]
[QUESTION_ID]
[RESPONSE]

TBL_LKUP
[COMBO_ID]
[COMBO_VALUE]
[SORT]

In order to enter survey responses, I have developed a form
(FRM_RESPONDENT) with a tab control consisting of five pages, each
representing a different section within the survey. Each of the five
pages is a sub form (FRM_RESPONSE_A, B, C, D, E) which is linked to
FRM_RESPONDENT by the shared RESP_ID field on both the form and sub
forms. The sub forms are set to continuous and the response field
(RESPONSE) is set as a combo box which queries its values in
TBL_LKUP. After a response is selected from the combo box, the
RESPONSE After Update event is set to update the RESP_ID field on the
subform based on the value in RESP_ID field on FRM_RESPONDENT. The
issue that I am now having is that that when I advance to a new record
on FRM_RESPONDENT, the combo box values are still populated with the
response from the previous record and if I attempt to select a new
value from the combo box, the RESP_ID changes to what is currently on
the FRM_RESPONDENT and the previous value is over written, as opposed
to a new record being created. Any thoughts on how I can 1) clear the
combo boxes when advancing to a new record and 2) how to not overwrite
the previous record's response would be greatly appreciated. Thank
you.

 

[NetworkTrade]

sounds to me that your design does not always & certainly advance to the next
record depending on user....

I would address this first; a button that says "enter" or something clearly
mandatory....

If your form always starts out ok in terms of those comboboxes....then at
the same time you can simply close and reopen the form...