Results 1 to 8 of 8
  1. #1
    Secue is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    33

    no data populated on a form on Form view


    Views: 7 Size: 445.1 KB">Design view.pdf
    Hi:

    I have a fomr on my databse where I'm showing information frm a table and a subtable. I have been working on it and today that I make some changes, sundenly I got a blank form. Not sure what I did, but when I set form on dsign view I can see all fields and the design of the form, but when I open it on View form, I just see the fram of the form.

    I checked and it has property Visible to Yes. Not sure what else I need to check or what could I did. I attacht screen shot's to clarify what I got.

    Thank you.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    The "usual suspect" is a record source that doesn't return any records or allow a new record.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Secue is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    33
    Pbaldy

    Thank you for your quick answer. So far my problem is that anything on the fomr is showed. Even the legends (text labels) or even the background it is jut the fram of the form window. I attached a file with pictures, but it looks like I did not do it properly and hiperlink for the file was added at the very begininig of my firts question. Yo may see it on the firts post, the text as hiperlink, Desing_View.pdf.

    Actually I have been working on the for during the morning, now that I just make the last change to add a button to the form (it was already in the form and I just added code on property "After click") is when I got this behavior, I even delete the software I added the the button. I close the program but still continues the same.

    Thank you.

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    I saw it; did you check the recordsource? Can you post the db here?
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Secue is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    33
    Attached database file. Form I have issues is "FormAdministartorSystem"
    Attached Files Attached Files

  6. #6
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Difficult to be sure with no data, but the main form's Allow Additions property is No, so if the SQL that's in the record source property doesn't return any records, you can see the behavior you're experiencing. That's also partly because everything is in the detail section.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    Secue is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Jun 2013
    Posts
    33
    pbaldy:

    The key words were "Difficult to be sure with no data", I check that I delete all record that I enter during test, to start form zero. I was hopping that even no data is available I will be able to see the fomr and the fields.

    So, I just enter one record on the tables (with another form I have to enter data) and now everything is working fine.

    Thank you.

  8. #8
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    No problem.
    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: 8
    Last Post: 04-29-2013, 11:23 AM
  2. Replies: 2
    Last Post: 10-31-2012, 07:52 PM
  3. Opening a form from another with pre-populated data
    By uaguy3005 in forum Programming
    Replies: 4
    Last Post: 07-09-2012, 06:05 AM
  4. Replies: 9
    Last Post: 02-19-2010, 12:07 PM
  5. Replies: 9
    Last Post: 03-24-2009, 09:19 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