0 Replies - 375 Views - Last Post: 24 August 2011 - 09:41 AM Rate Topic: -----

#1 lacrue79  Icon User is offline

  • New D.I.C Head

Reputation: 2
  • View blog
  • Posts: 43
  • Joined: 12-August 09

Data Grid View Error "Child list for field..." "....cannot

Posted 24 August 2011 - 09:41 AM

Hello, I'm creating a connection to a database for the first time and I'm having an issue with an error that I'm receiving. The error states "Child list for field Custom_Extracts cannot be created". Here is my code...

Dim dbpath As String
        dbpath = Application.StartupPath + "\" & "CDE Database.accdb"
        Me.DgCustomQueries.DataSource = dbpath
        Me.DgCustomQueries.DataMember = "Custom_Extracts" 'This is the line of code which gives me the error.

My database is called "CDE Database" and the Table that I'm trying to pull from is called "Custom_Extracts".

I've put a datagrid onto my user form and titled that DGCustomQueries

I'm setting my DataSource to call the "CDE Database"

I want to set the DataMember as my "Custom_Extracts" table.

I don't know if it will help any but I added a reference to the Microsoft DAO 3.6 Object Library.

Thanks everyone!

Is This A Good Question/Topic? 0
  • +

Page 1 of 1