Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2009
    Location
    Cairo
    Posts
    7

    How when u open a form u see an entry for new record??

    People when open the form see the first record? How can I let them open a blank fields (New record).

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Set the DataEntry property to YES.

  3. #3
    Join Date
    Feb 2009
    Location
    Cairo
    Posts
    7
    Quote Originally Posted by RuralGuy View Post
    Set the DataEntry property to YES.
    I made a Macro that runs a command addnew record OnOpen event of the form. But thx for answering.

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Glad you got it sorted.

  5. #5
    rommelgenlight is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Mar 2009
    Posts
    77
    you can also make an On Load or On Open Even Procedure.

    you can go to a new record with the command

    docmd.GoToRecord,,acNewRec

    and set the forms Key Preview Event to Yes and On Key Down event to:

    Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
    Select Case KeyCode
    Case 33, 34
    KeyCode = 0
    End Select
    End Sub

    in this way, the they cannot use the page up and down to move to any records.

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

Similar Threads

  1. Replies: 0
    Last Post: 10-16-2008, 02:39 PM
  2. Date Stamp On Entry of Record
    By tscholts in forum Forms
    Replies: 3
    Last Post: 04-01-2008, 07:08 PM
  3. In a field on a Form, on click open another form
    By jackieagra in forum Programming
    Replies: 1
    Last Post: 03-20-2008, 09:44 AM
  4. Form will not open
    By dserbanescu in forum Forms
    Replies: 0
    Last Post: 01-09-2008, 09:48 AM
  5. Run report or sub form during data entry
    By wasim_sono in forum Programming
    Replies: 0
    Last Post: 03-09-2006, 05:40 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