Results 1 to 2 of 2
  1. #1
    Bkndbrown is offline Novice
    Windows 8 Access 2013
    Join Date
    Nov 2015
    Posts
    22

    filter on load and allow create new entries

    I have a form that I am opening with a button with the following.

    Private Sub Open_Main_Click()


    DoCmd.OpenForm "test300", , , "selectunit_tbldropdownsqdn=true"




    End Sub

    This works for the filter however I also need to be able to allow new entries in this form and I loose that ability.

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,398
    shouldn't do - the two properties are separate. Filter filters, allow additions allows new entries

    Check your form properties and any code that might be setting allowadditions to false

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

Similar Threads

  1. Filter Form On Load
    By Juan4412 in forum Forms
    Replies: 5
    Last Post: 04-12-2017, 12:09 PM
  2. Replies: 14
    Last Post: 12-28-2015, 07:51 AM
  3. filter load
    By slimjen in forum Forms
    Replies: 11
    Last Post: 08-06-2014, 10:25 AM
  4. Replies: 1
    Last Post: 05-20-2013, 01:45 PM
  5. Filter a control on load
    By nick.h in forum Forms
    Replies: 1
    Last Post: 12-01-2011, 02:46 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