How to open a blank form?

[WhatnThe]

Can anyone tell me how to start with a blank form when I open my access database? When I open it now it opens with the last record entered.

[jbarrum]

Open the form in dessign view and go to the form properties. Click on the Data tab and change the field "DataEntry" to "Yes"

[WhatnThe]

There isn't an value in the data tab. There is Control Source, Text Format, Imput Mask, Default Value, Validation Rule, Validation Text, Filter Lookup, Enabled, Locked, & Smart Tags. Would I be looking in the wrong area? The first item in my form is a combo box

[MAF4Fam6]

You can have Access auto open the form on a new blank record using VBA or a Macro in the Form's Event Properties: On Load Event
In a Macro...use the GoToRecord Action and change the action arguments to New instead of Next in the Record property.

-RC

[Rainlover]

Can anyone tell me how to start with a blank form when I open my access database? When I open it now it opens with the last record entered.

Are you sure it opens with the Last Record. This is not normal behaviour.

[WhatnThe]

I am not sure if it is the last record but, when I open the form it's already populated with text. I just assumed it was the last information entered. I am still not sure how to open with a blank form.

[Rainlover]

In Form Design.

Go to Properties.

Go to the Data Tab.

Data Entry should be "YES"

[WhatnThe]

I went to Go to Properties, then I clicked the Data Tab. I am not seeing the Data Entry. I have uploaded a demo of what I am working on in My Calculating Values post you just replied to. If you take a look you will see what I mean. Please tell me if I was looking in the wrong area.

https://www.accessforums.net/access/...0-newpost.html

[Rainlover]

I got your Demo version.

Change the Control source to PcsProduced.

Then go back and reread the link that was mentioned by RG.

[Rainlover]

Try this as attached.

[WhatnThe]

Can you tell me what you did? I am attempting to compare my 07 version against your 03 version and I the only difference I am seeing is the source control in PcsProduced was changed. I am looking at my form can now see that PcsProduced is being recorded in my database however the output number does not show up in my in its form field.

I am a visual learner this is why I asked.

[Rainlover]

First of all I think I am replying to the other post of yours.

Have a look at the code behind the form.

Again go back and look at the link that you were directed to by RG.

[WhatnThe]

In a Macro...use the GoToRecord Action and change the action arguments to New instead of Next in the Record property.
-RC

I have this macro attached to my add record button but, when I close & reopen my database its still populated with previous text.

[MAF4Fam6]

You will need to add the Macro to the Form's main properties. Adding the Macro to a command button or field's properties will not work.
Thanks.

-RC

[WhatnThe]

In Form Design.

Go to Properties.

Go to the Data Tab.

Data Entry should be "YES"

You were correct with what you said. I found I did not have the correct Selection Type: Once I selected "Form" the options for data type appeared. This issue has been solved thanks to all for your input. I will have more questions throught the night but I need to take a break I have been at this for over 5 hours. BBL