Disclaimer: I may not have an opportunity to comment again for a couple days.
Question - What version of Access & VB are you using? If I'm not mistaken, Datagrids are a .Net control. Are you linking to an external non-access database?
Now, if you're talking about a Dataview - just a display view for a query, try opening up a new form and selecting a table or query to bind to it and then select dataview as the default way it displays the results inside the form.
If you start peeking around at the form properties in design mode, you'll find some entries in the Recordsource or Rowsource properties that relate to the choices you made using the wizard interface.
I'm using Access 2003 under XP prof. The control that I'm looking at is an ocx control called "VideoSoft FlexArray Control" that came with Access. It paints a very nice configurable grid control on a form but I can't find any way to link it to data. Alternatively I found an Excel type grid called Microsoft Office Spreadsheet 11.0 and I can't find any way to link that to data either. I don't really want to simulate a grid using a data sheet. I'm actually trying to work towards an interactive Sasco type chart.
As Vic mentioned, use a subform and display it in Datasheet mode -- that is the simplest way to show one-to-many datasets in Access.
If you really need a flexgrid, here is a link that may help. To be honest, there's not a lot of useful info out there for Access and Flexgrids -- they are really intended more for VB and VB.Net projects.
I have no idea if this will help you. I've never used that particular object within Access, however, I have done a limited amount of work with datagrids in .Net.
Datagrids in .Net work in a fashion that really is completely different from recordsets and ADODB type connections. This is a snippet from some code I wrote, however, it's pretty generic so I included it here. Again, to emphasize, this is not VB6.0.
adapter = New OleDb.OleDbDataAdapter(sqlStatement, connection)
accessData = New DataTable("theData")
Dim ds As DataSet
ds = New DataSet("theData")
dgResults.DataSource = ds
'Clear any bindings from the DataGrid and set the DataSource of the DataGrid
'to the new excelData DataTable
dgResults.DataSource = accessData
Working with individual records and/or fields requires you to work wish DataColumn & DataRow objects.
I'm thinking you'll do better to work with something else, however.