Results 1 to 7 of 7
  1. #1
    buck is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    26

    Open Form to be blank


    I have a form linked to a query. The form has a combo box to search for by claim #. I would like this form to open with no previous record values showing. I do not want to the form to be set as data entry. Is there a way to do this?

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    If you do not want the form's Data Entry property to = Yes then I believe the only option left is to not have it bound. Why not place your combo on a main form that is unbound and use a subform to link to your query? You could use the .Visible property to hide your subform and .Recordsource to adjust the recordsource.

  3. #3
    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
    Or you could simply open the Form to a New Record:
    Code:
    Private Sub Form_Load()
     DoCmd.GoToRecord , , acNewRec
    End Sub

    Linq ;0)>

  4. #4
    buck is offline Novice
    Windows 8 Access 2010 64bit
    Join Date
    Dec 2013
    Posts
    26
    This worked perfectly. . . thank you.

    Quote Originally Posted by Missinglinq View Post
    Or you could simply open the Form to a New Record:
    Code:
    Private Sub Form_Load()
     DoCmd.GoToRecord , , acNewRec
    End Sub

    Linq ;0)>

  5. #5
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I see. I suppose that does avoid setting the form's property as data entry. There could be advantages/distinctions in doing it this way.

  6. #6
    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
    Sure; it just depends on your needs! And since the OP is using a Combobox to retrieve Records, he cannot set Data Entry to Yes. With that setting, the Record Source of the Form does not contain any previously existing Records, only Records entered during that session.

    Your suggested approach was just fine, it just involves a lot of work for a newbie.

    Linq ;0)>

  7. #7
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I was not considering why the OP did not want to employ Data Entry. Perhaps some sdditional property settings and code can prevent an accidental addition and or saving of a record.

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

Similar Threads

  1. Replies: 3
    Last Post: 11-03-2013, 09:53 PM
  2. Form keeps showing up blank on open
    By rthakral in forum Forms
    Replies: 3
    Last Post: 09-24-2013, 01:35 PM
  3. How to open a blank form?
    By WhatnThe in forum Access
    Replies: 15
    Last Post: 08-05-2011, 02:41 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