Results 1 to 4 of 4
  1. #1
    srmezick is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    15

    Form not showing information in querry

    I have a multiple items form that runs off a query, but doesnt show all of the information in the querry. The columns are there, but they do not contain any data, even tho the data shows in the query. Any ideas? Ive attached screenshots.

  2. #2
    srmezick is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    15

    Better screenshot

    those screen shots were not very informative. For example, an employees position shows on the querry but on the form the column is blank. The same with thier type of exception.

  3. #3
    Join Date
    Nov 2011
    Location
    Hamilton, NZ
    Posts
    18
    what joins are you using in your query....

  4. #4
    srmezick is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Oct 2011
    Posts
    15
    I think what you are asking me is what the relationship betweeen the tables I have querried are? All of the tables in my database are joined by the employee ID, which is set up with the retain integrity and cascading updates and deletes for that primary key and foreign key relationships.

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

Similar Threads

  1. Replies: 5
    Last Post: 10-27-2011, 10:25 AM
  2. Information in tabbed form
    By dunnmel4 in forum Forms
    Replies: 7
    Last Post: 03-27-2011, 04:32 PM
  3. Export Form but Keep Information?
    By SpeedyApocalypse in forum Forms
    Replies: 4
    Last Post: 04-09-2010, 07:30 AM
  4. Moving Information from One Form to Another
    By bsharpbyoung in forum Forms
    Replies: 2
    Last Post: 03-22-2009, 09:37 PM
  5. Form that hides information
    By dromorkid in forum Forms
    Replies: 0
    Last Post: 11-04-2008, 11:25 AM

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