Refresh form

[linda sciallo]

I have a form where I can enter New Request information. There is a button on the form that allows you to save the data by clicking on it. A message box comes up and asks if you want to create a new request. If you click the Yes button, the New Request form is displayed, but the form is not refreshed (the fields still contain the data that was entered from the prior request).

How to I get the form to refresh (clear out the data that was there previously)??


Thanks.

 

[Jack Cowley]

Either set the forms Data Entry property to Yes or when the user selects Yes then use this code:

DoCmd.GoToRecord , , acNewRec