I'm student in aviation management. I don't have any background on IT/VBA. I were ask to do Questionnaire Using ms access but the problem is i have done the Questionnaire when the person answer and submit the answer. the answer save to the table and the problem start when the second person open the questionnaire there is still answer that have been answer. how can it be refresh when the second person enter the questionnaire will be clear.
-
-
Knight02,
If your Questionnaire is on a new record, all the responses should be blank. Is your form bound or unbound? A bound form should have no problems like this. -
If your form is bound to your table and still having this issue, try putting this code in your "Submit" button on click event.
Code:DoCmd.GoToRecord , , acNewRec
Comment
-
Twinnyfo Sorry i don't quite understand... what do you mean by my form is bound or unbound? if the form is attach with the table mean it bound... yes my form is bound...Comment
-
Dpot may I know where to enter this code... sorry i have no IT nor VBA knowledge...Comment
-
Knight,
Dpot has the right idea--as long as you go to a new record, your values should be clear for the new responses.Comment
-
twinnyfo okey... I don't know where to put the code given by the Dpot. If its in VB. I have tried so but no changes...Comment
-
Knight02,
Do you have a button on the form that must be clicked to submit your answers? If so go to the buttons "onclick" event in the properties menu, you paste the code in there.Comment
Comment