Results 1 to 7 of 7
  1. #1
    ddde is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    2

    I designed a form in Access 2016. No fields were present when I opened it in form view or layout vi

    I am not an expert in Access by any means. I have successfully designed other forms and have not had any issues. The design is pulling in fields from a number of tables. I saved the form and when I opened it in form or layout view, there was only a white page. On the property sheet of the form, Data Entry, Allow Additions, Allow Deletions, Allow Edits and Allow Filters are set to Yes.

    Any help would be appreciated!

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,920
    Data Entry set to Yes only allows entry of new records and will not allow display of existing records. However, should see labels.

    Normally a form is set up for entry/edit to one table. Why are you including multiple tables?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  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
    Quote Originally Posted by ddde View Post

    The design is pulling in fields from a number of tables.
    Forms based on multi-tables are frequently Read-Only...and Read-Only Forms, that have no Records, in the underlying Record Source, will present as you've described...without even the Controls showing. Is that the case here?

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    ddde is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2018
    Posts
    2
    Sorry for the delay in responding.

    June7: I recreated the table as one table and the form. When I attempt to open the form in Form View, I get a Enter Parameter Value dialog box. It refers to Client Info.Significant Other where Client Info is the name of the table and Significant Other is the field name. Any ideas?

    MissingLinq" There is nothing to indicate a field is read only in the tables or the form.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,920
    Access cannot find a field by that name.

    Advise not to use spaces nor punctuation/special characters (underscore only exception) in naming convention.
    Last edited by June7; 06-26-2018 at 05:56 PM.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    davegri's Avatar
    davegri is online now Excess Access
    Windows 10 Access 2016
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,411
    Data names with spaces need to be in brackets like this:
    [Client Info].[Significant Other]

  7. #7
    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
    Quote Originally Posted by ddde View Post

    ...MissingLinq" There is nothing to indicate a field is read only in the tables or the form...
    Sure there is...

    Quote Originally Posted by ddde View Post

    ...The design is pulling in fields from a number of tables...
    As I said...Forms based on multi-tables are frequently Read-Only...and the fact that the Form has Fields from a number of Tables means that the Form is based on a multi-table Query!

    This behavior is classic for the scenario I described...a Read-Only Form with no existing Records.

    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: 10
    Last Post: 02-06-2018, 02:37 PM
  2. Replies: 4
    Last Post: 04-14-2017, 05:03 PM
  3. Replies: 6
    Last Post: 05-09-2014, 09:03 AM
  4. Replies: 6
    Last Post: 03-08-2014, 12:47 PM
  5. Replies: 7
    Last Post: 02-11-2011, 08:00 AM

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