Results 1 to 3 of 3
  1. #1
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147

    Subform will not show data

    I have 2 subforms in a form that will not show data. When you put data in the first subform it will take it but will disapear when you refresh the screen. When I check the table it is there. All three tables have unique names.

    The second table gives me this error when I try to enter data: "the object doesn't contain the automation object 'Entryid'".

    All allows are set to yes for deletion, addition etc.

    On current on the 1st subform I have this VB script:

    Sub Form_Current()
    ' This code created by Form Wizard.
    Dim strParentDocName As String
    On Error Resume Next
    strParentDocName = Me.Parent.Name
    If Err <> 0 Then
    GoTo Form_Current_Exit
    Else
    On Error GoTo Form_Current_Err
    Me.Parent![tblCommitteeData Subform2].Requery
    End If
    Form_Current_Exit:
    Exit Sub
    Form_Current_Err:
    MsgBox Err.Description
    Resume Form_Current_Exit
    End Sub

    I have been trying to figure this out for 4 days and I am not any closer than I started.

    DB Attached.

  2. #2
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    Oops, here it is!

  3. #3
    Brian62 is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Aug 2009
    Posts
    147
    I figured out the problem. The Data Entry was set to Yes on both subforms when they should be set to No. All others should be set to Yes for Additions, Deletions etc. The 2nd subform had the wrong Link Child Field. Should of been set to EntryID2.

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

Similar Threads

  1. Show Recordset in unbound subform
    By vgarzon in forum Forms
    Replies: 4
    Last Post: 03-02-2011, 04:11 PM
  2. how to show all data in this querey
    By grad2009 in forum Queries
    Replies: 3
    Last Post: 02-08-2010, 07:35 AM
  3. Show all recordset in form/subform
    By Brian62 in forum Forms
    Replies: 4
    Last Post: 11-04-2009, 11:56 AM
  4. Replies: 4
    Last Post: 10-29-2008, 11:53 AM
  5. All Data wont show
    By Wrangler in forum Queries
    Replies: 1
    Last Post: 01-02-2006, 03:27 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