DoCmd for a field refersh

[Moxioron]

Hello.

I think this is probably an easy question...

I have a data entry form with several fileds that load into a table. That part works great except when I select the Save command button, I want the form to save and clear the fields.

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , , acMenuVer70

How would I go about doing that? Thanks.

 

[SydneyGeek]

Do you specifically need to save the record?
You could just DoCmd.GoToRecord , , acNewRec


Denis

 

[Moxioron]

Yes, I would like the information to save on the table when the 'Save' control button is selected, which works great. But after the data is saved I want the files on the formed zeroed out for the next data entry item.

 

[Norie]

That should automatically happen - all the fields should be set to their default when you goto a new record.

 

[Moxioron]

When I select the command button, it does populate the table fine, but doesn't zero out the fields for the next entry. The previous record information still remains....

 

[Norie]

So how are you going to a new record?

If you aren't you need to add code like Denis posted to move to a new record.

 

[boblarson]

1. You should NOT use DoMenuItem code. That is old legacy code which isn't all that informative as to what it is doing. Use the DoCmd.RunCommand code instead.

2. If you are using any unbound controls then you would need to clear them in code but it depends on what you are doing with your form as to when and how you would need to do this.

 

[HiTechCoach]

My assumption is that the form is bound since you are doing a save record.

To clear the form you need to navigate to a new (blank) record. This will automatically clear all the bound controls on the form.

Your save button could use soemtihg like thia:

' Save the record 
If Me.Dirty = True then Me.Dirty = False
 
' go to a new blank record
 DoCmd.GoToRecord , , acNewRec

 

[Moxioron]

Works. Thanks!