Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening a form with all textboxes empty (MS access 2007)

    A form that is used to manage customers shows when it opens the data of a customer .
    What has to be done so that this form after opening shows only empty textboxes , and by mean of buttons must be set in browser-mode or data-entry mode or editing-mode?
    As recordsource for the form serves a query that get all current customers.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Opening a form with all textboxes empty (MS access 2007)

    You could move to a blank new record when the form is opened:

    Private Sub Form_Load()
    On Error Resume Next
    RunCommand acCmdRecordsGoToNew
    End Sub

    You can set the AllowEdits, AllowAdditions and AllowDeletions properties of the form using code.

  3. #3
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Brugge, Belgium
    Posts
    144
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening a form with all textboxes empty (MS access 2007)

    Thanks for the help

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •