Results 1 to 4 of 4
  1. #1
    Trace is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2022
    Posts
    12

    Form goes blank in form (and layout) view after adding a new field

    Hello and thanks for your help on this issue!

    My form was coming along nicely, then I needed to add another field to it. When I did, after switching to form view, the fields were no longer visible. The form is essentially blank, except for the header, but I can still see all the fields in design view.



    I have checked the usual suspects:
    There is one record so far to display.
    Recordset Type is Dynaset
    Allow Additions: yes

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,800
    I suspect that it isn't due to adding a field, rather it is because something happened such that there really is no record to show and the underlying query (if there is one) is now not updatable. If that's not it, then I don't know but you could read this. If that doesn't help, maybe copy db, compact/repair, zip it and post the copy here.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,654
    Is there more than one table involved? You may have improper joins.
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  4. #4
    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
    This is the classic description of the GUI when

    1) Access is set to Allow New Records/Edited Records
    2) The Form's underlying Record Set is Read-Only, for whatever reason.

    There can be a number of reasons for #2, including basing the Form on a Multi-Table query.

    What is the Form based on (Table, Single Table Query, Multi-Table Query?)

    Does the added field reside in the same Table as the rest of the data? In a different Table?

    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. Replies: 1
    Last Post: 11-27-2018, 04:54 PM
  2. Replies: 10
    Last Post: 02-06-2018, 02:37 PM
  3. Form is blank in form and layout view
    By jeff_18808 in forum Forms
    Replies: 5
    Last Post: 01-11-2016, 01:22 PM
  4. Replies: 6
    Last Post: 03-08-2014, 12:47 PM
  5. Adding field to form causes blank view.
    By emccalment in forum Access
    Replies: 1
    Last Post: 04-02-2010, 06:27 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