Results 1 to 3 of 3
  1. #1
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90

    Table/Query acting wierd

    I have never experienced this phenomena and maybe you guys have - I hope. This has had me occupied most of the day.



    T_Main has an attribute linked to T_Attribute (primary keyed). T_Main has the linked attribute set to "Limit to List".

    When viewing T_Main attribute you see the drop-down and when testing it, it will only allow blanks or attributes form T_Attribute to be selected.

    Good so far, right? So here's my problem.

    T_Main has 1,300 records which appear to be blank (null) in the attribute column but when running a query to pull all nulls it says there are none!

    Also, when initially opening T_Main, the first record shows an attribute until you run the pointer into that cell and then the attribute disappears.

    I have rebuilt the table - nada. Rebuilt the query - nada. What else should I be trying?

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    I would look at the lookup behind on the attribute field in your main table. Have a look at the rowsource and see how many fields there are. Is this the same amount as the column count. Also look at the column widths as any zeros will make the field invisble.

  3. #3
    Rick West is offline Advanced Beginner
    Windows XP Access 2007
    Join Date
    Jul 2009
    Posts
    90
    I did have the look up set to 2 columns from a 2 column table with the first column set to 0" so it would not show. I have opened that up now and will test it later today. I'll let you know what happens. Thanks for the hints.

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

Similar Threads

  1. docmd.rename wierd results
    By hyperionfall in forum Programming
    Replies: 1
    Last Post: 03-04-2010, 01:18 PM
  2. Replies: 0
    Last Post: 02-24-2010, 12:56 AM
  3. Replies: 0
    Last Post: 12-21-2009, 12:15 AM
  4. Wierd subdatasheet problem
    By Lynnwood in forum Access
    Replies: 0
    Last Post: 10-30-2009, 08:12 PM
  5. Replies: 2
    Last Post: 10-27-2009, 07:09 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 - Senior Forums