Page 1 of 2 12 LastLast
Results 1 to 15 of 16

Thread: How to open a blank form?

  1. #1
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50

    How to open a blank form?

    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.

  2. #2
    jbarrum is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2009
    Location
    Houston, Tx
    Posts
    164
    Open the form in dessign view and go to the form properties. Click on the Data tab and change the field "DataEntry" to "Yes"

  3. #3
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50
    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

  4. #4
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140

    Post

    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; 12-31-2009 at 10:25 PM.

  5. #5
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    636
    Quote Originally Posted by WhatnThe View Post
    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.

  6. #6
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50
    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.

  7. #7
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    636
    In Form Design.

    Go to Properties.

    Go to the Data Tab.

    Data Entry should be "YES"

  8. #8
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50
    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.

    http://www.accessforums.net/access/c...0-newpost.html

  9. #9
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    636
    I got your Demo version.

    Change the Control source to PcsProduced.

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

  10. #10
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    636
    Try this as attached.
    Attached Files Attached Files

  11. #11
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50
    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.

  12. #12
    Rainlover's Avatar
    Rainlover is offline Expert
    Windows XP Access 2003
    Join Date
    Nov 2009
    Location
    Queensland Australia
    Posts
    636
    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.

  13. #13
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50
    Quote Originally Posted by MAF4Fam6 View Post
    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.

  14. #14
    MAF4Fam6's Avatar
    MAF4Fam6 is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Dec 2009
    Location
    Fruit Heights, Utah USA
    Posts
    140

    Post

    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

  15. #15
    WhatnThe is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Dec 2009
    Posts
    50
    Quote Originally Posted by Rainlover View Post
    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

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. I want my form to open blank
    By uneek78 in forum Forms
    Replies: 10
    Last Post: 01-12-2011, 11:01 AM
  2. blank on entry on add a record form
    By gmee in forum Forms
    Replies: 1
    Last Post: 10-07-2009, 06:31 AM
  3. Replies: 1
    Last Post: 03-15-2009, 03:46 PM
  4. Replies: 1
    Last Post: 09-05-2008, 11:07 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums