Results 1 to 7 of 7
  1. #1
    ShaunG is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jan 2018
    Posts
    237

    work diappeared

    all of a sudden form is not showing information or details in form section, the header still has all the buttons and detail in it though.... has any one had this?

  2. #2
    ShaunG is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jan 2018
    Posts
    237
    Click image for larger version. 

Name:	Untitled2.jpg 
Views:	7 
Size:	231.6 KB 
ID:	32291Click image for larger version. 

Name:	Untitled3.jpg 
Views:	7 
Size:	92.2 KB 
ID:	32292

    this is design view and form view.....

  3. #3
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Check the form's Record Source property
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  4. #4
    ShaunG is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jan 2018
    Posts
    237
    Quote Originally Posted by Bob Fitz View Post
    Check the form's Record Source property
    yeah that sorted it..... thought it was up the fritz lol

    was that because to much info going in?

  5. #5
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    This can happen where the record source has more than one table with an inner join.
    If there is no record in one if the tables, the record source will be empty and the form blank.

    Populate the missing record or use an outer join to fix it.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  6. #6
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by ShaunG View Post
    yeah that sorted it..... thought it was up the fritz lol

    was that because to much info going in?
    Who knows ?
    I suspect that you deleted it inadvertently
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  7. #7
    ShaunG is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    Jan 2018
    Posts
    237
    Quote Originally Posted by ridders52 View Post
    This can happen where the record source has more than one table with an inner join.
    If there is no record in one if the tables, the record source will be empty and the form blank.

    Populate the missing record or use an outer join to fix it.
    thanks guys..... I don't know much on how the joins work even though im probably using them in places. e

    rased all the record source and that fixed nicely

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

Similar Threads

  1. DLookup won't work
    By Paul H in forum Access
    Replies: 5
    Last Post: 12-09-2016, 10:26 AM
  2. Can't get it to work..
    By Voodeux2014 in forum Forms
    Replies: 1
    Last Post: 02-16-2015, 09:41 AM
  3. Replies: 4
    Last Post: 12-06-2014, 08:49 PM
  4. can't we just work together?
    By ldodge in forum Queries
    Replies: 4
    Last Post: 10-15-2011, 06:42 AM
  5. how does mdw work?
    By raffie77 in forum Security
    Replies: 2
    Last Post: 08-17-2011, 12:43 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