Results 1 to 6 of 6
  1. #1
    Altaful Haq is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2014
    Location
    Swat, KPK, Pakistan
    Posts
    22

    clearing form as the form open

    as there a way to clear a form aa it open. . . .

  2. #2
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Did you mean at the open shows empty without data?

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,642
    Perhaps setting the Data Entry property of the form to Yes does what you want?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  4. #4
    Altaful Haq is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2014
    Location
    Swat, KPK, Pakistan
    Posts
    22
    yes I mean it.

  5. #5
    azhar2006's Avatar
    azhar2006 is offline Expert
    Windows 7 32bit Access 2007
    Join Date
    Mar 2012
    Posts
    528
    Private Sub Form_Open(Cancel As Integer)
    DoCmd.GoToRecord , , acNewRec
    End Sub

  6. #6
    Altaful Haq is offline Novice
    Windows 8 Access 2013
    Join Date
    Feb 2014
    Location
    Swat, KPK, Pakistan
    Posts
    22
    Thanks Azhar

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Clearing a search box on a form
    By pbouk in forum Forms
    Replies: 13
    Last Post: 02-06-2013, 04:54 PM
  2. Clearing a Form
    By dabatman in forum Forms
    Replies: 4
    Last Post: 01-20-2012, 11:51 AM
  3. Clearing a form - having real issues
    By mike_980 in forum Forms
    Replies: 9
    Last Post: 01-11-2012, 06:15 AM
  4. Error when clearing form
    By turbo910 in forum Forms
    Replies: 11
    Last Post: 11-26-2009, 11:03 AM
  5. clearing a form
    By macsterling in forum Forms
    Replies: 0
    Last Post: 07-31-2008, 10:38 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
  •  
Other Forums: Microsoft Office Forums