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.
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.
Open the form in dessign view and go to the form properties. Click on the Data tab and change the field "DataEntry" to "Yes"
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
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
Last edited by MAF4Fam6; 01-01-2010 at 12:25 AM.
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.
In Form Design.
Go to Properties.
Go to the Data Tab.
Data Entry should be "YES"
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
I got your Demo version.
Change the Control source to PcsProduced.
Then go back and reread the link that was mentioned by RG.
Try this as attached.
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.
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.
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
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