Refreshing a form upon opening

[an1bone]

Hello,

I have created a form to enter new records that will be saved into an existing table. I have multiple textboxes where administrators will be able to enter in new part numbers, image file locations, hyperlinks to documents, etc. I added an Add Record command button (to add the new record to the table), as well as an Undo Record command button (to get rid of the data partially entered into this form). My problem is that whenever I open the form up, it displays all of the data for a previous record already saved in the table. I need to click the Add Record button in order for this data to go away and then add a new record. Also, an error message comes up saying the Undo command isn't available when I try to click Undo Record to remove this data upon opening the table. What macro can be used to sort of "refresh" this form when it is opened? I've tried adding Refresh when opening and loading, but it just comes up with an error message. I just want the form to come up free of data when it opens. Thank you for your help!!!

[ranman256]

the form is resting on the last record,
if you want to open it for data entry ,new record, then

docmd.openform "frmMyform",,,,acFormAdd

[an1bone]

Where do I use this docmd.openform "frmMyform",,,,acFormAdd ?? I'm still fairly new to access...

[JamesDeckert]

Wherever it is that you're opening the form from. If a button opens the form, use ranman's code in the button click event

[ranman256]

how is the form opened to begin with?
is it opened when the db opens?
is it opened when a user clicks a button on the main menu?

[Homegrownandy]

If you are using a macro to open the form you need to change data mode to ADD. It will open on a new every time then. If you then take off any navigation it will always be a blank form when opened through that button and the same form can be used to open specific records also.