Results 1 to 2 of 2
  1. #1
    dmon2010 is offline Advanced Beginner
    Windows Vista Access 2007
    Join Date
    Sep 2013
    Posts
    39

    Open to Blank form and use Find button

    I have a form that I've set to open to a blank record so information can be entered as soon as the form is open. However, sometimes I'd like to go in and search for a record as soon as I open the form instead of entering info. When I try to use the "find record" button, i am unable to do so... any help would be appreciated. Thanks in advance.

  2. #2
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Quote Originally Posted by dmon2010 View Post

    ...I have a form that I've set to open to a blank record so information can be entered as soon as the form is open...
    How, exactly, have you accomplished this? If you have the Data Entry Property set to Yes the existing Records aren't available, and hence 'Find' is useless. If that's the case, change the Data Entry Property back to No, and use this code to open to a blank, new Record:
    Code:
    Private Sub Form_Load()
      DoCmd.GoToRecord , , acNewRec
    End Sub

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Open Form to be blank
    By buck in forum Forms
    Replies: 6
    Last Post: 01-10-2014, 03:04 PM
  2. How to open a blank form?
    By WhatnThe in forum Access
    Replies: 15
    Last Post: 08-05-2011, 02:41 PM
  3. Replies: 5
    Last Post: 03-03-2011, 03:56 PM
  4. I want my form to open blank
    By uneek78 in forum Forms
    Replies: 10
    Last Post: 01-12-2011, 01:01 PM
  5. Replies: 4
    Last Post: 10-20-2010, 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