Results 1 to 3 of 3
  1. #1
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132

    acFormEdit is allowing form additions

    Hi, all! I have a button (Command20) on a form that opens another form (EventInviteF). The properties of EventInviteF set "Add" to no.



    However, the following comman behind the button still allows additions to the form. Is there something I need to add or change?


    Private Sub Command20_Click()
    DoCmd.OpenForm "EventInviteF", , , , acFormEdit
    End Sub


    With thanks!

    --al

  2. #2
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows XP Access 2003
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,610
    perhaps you need:

    Private Sub Command20_Click()
    DoCmd.OpenForm "EventInviteF", , , , acFormPropertySettings
    End Sub
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  3. #3
    kelann is offline Learning ... thank you!!
    Windows XP Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    132
    Ah, perfect! Thank you! This was recommended to me in another thread, but I thought I was supposed to substitute "what I want" for the phrase "PropertySettings" -- so I did "FormEdit".

    Thank you so very much, Bob!!!

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

Similar Threads

  1. Replies: 9
    Last Post: 10-17-2012, 11:37 AM
  2. Allow Additions Msg Box
    By rossi45 in forum Forms
    Replies: 3
    Last Post: 04-23-2012, 02:51 PM
  3. Allow additions on .accdr
    By dougie in forum Forms
    Replies: 0
    Last Post: 02-20-2012, 05:17 AM
  4. Form not allowing new entry
    By Lshy01 in forum Forms
    Replies: 1
    Last Post: 02-04-2011, 10:19 AM
  5. Multi-record additions using a list box not working right
    By avarusbrightfyre in forum Programming
    Replies: 3
    Last Post: 10-27-2010, 01:50 PM

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