Results 1 to 3 of 3
  1. #1
    GeekRose is offline Novice
    Windows 10 Access 2016
    Join Date
    May 2023
    Posts
    1

    Need form to open to new record for data entry

    I have a db that has been in use for 12 years - no code change, but the button that used to open up a form for data entry now just opens to a gray screen with no fields showing. I have compared the Property Sheet and the VBA to another db that does the exact same thing, on same network, just a different set of users accessing (data is controlled via network access - so yep, any changes have to be replicated in each separate db - no changes to any since August 2022). Here is the VBA code in my non-working db (but it's the same in a working one, so don't think this is it - but I've compared everything I can compare; restored back a week prior to when it last worked; and still nothing.



    Option Compare Database
    Option Explicit


    Private Sub Toggle0_Click()


    End Sub


    Private Sub Command11_Click()
    DoCmd.Quit
    End Sub


    Private Sub Command8_Click()
    DoCmd.OpenForm "INPUT CHANGE DATA", acNormal, , , acFormAdd
    DoCmd.Close acForm, "Main Form"
    End Sub

    Access 2016, running on a Win 10/Pro pc. db is on network drive.

    I appreciate your help!!

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,914
    Check for office and window updates, and rollback one at a time.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    I would also check the form's record source. Opening without controls would suggest that it no longer allows new records.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 9
    Last Post: 03-01-2017, 10:00 AM
  2. Replies: 7
    Last Post: 10-13-2016, 12:32 PM
  3. create a button to open a form for data entry
    By dave john in forum Programming
    Replies: 3
    Last Post: 08-21-2012, 08:41 AM
  4. Open report from data entry form
    By pbuecken in forum Forms
    Replies: 5
    Last Post: 01-14-2012, 12:07 PM
  5. Replies: 4
    Last Post: 03-24-2009, 09:07 PM

Tags for this Thread

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