Blank form at data entry

[joce]

Hi,

Wondering if anyone can help. I have several forms incorporated into a tab control, the problem being is that when I go into it to enter new data into each form, the fields are filled with the data that had been entered the previous day. The only way to change this to a fresh blank form page is to press the button at the bottom of the form.

Is there anyway that i wouldnt need to do this? I.E. when I go into the form control, and each form, there is an empty blank form to fill in, and when i click into the next form in the subform it saves what is entered

Any ideas anyone at all??

 

[MStef]

In Sub Form_Load put this code;
DoCmd.GoToRecord , , acNewRec

 

[missinglinq]

In each Form where you desire this behavior use this code

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

Not really sure what you mean by and

when i click into the next form in the subform it saves what is entered

How many 'forms' do you have in your Subform? Do you possibly mean when you click into the next Record in the Subform?

Linq ;0)>

 

[joce]

I have about 10 forms within my tab control. Where exactly do I enter in the code which you have advised?

 

[missinglinq]

MStef and I are both assuming that you have a different Form placed on each Tabbed Page as a Subform. You'll have to place the code in the Code Module of each of these Forms.

Assuming each of these Forms are Bound to a Table or Query, as they should be, as you leave one of these Subforms and move to another the previously entered Record will be saved.

Linq ;0)>

 

[joce]

this doesnt seem to be working.

I entered what you told me in the code sectionof the form but its not showing me a blank form everytime I open the form. Any ideas?

The form which I am trying to do it in is called: frmPre-CalvingGroup

If this makes any difference?