I am a SQL guys who spends very little time in MS Access. I have a small project in Access where I will be using a form to build dynamic sql against the local jet database. Upon clicking a command button I would like to go to the DB with something like
rst=CurrentDB.OpenRecordset(strSQL)
...and then populate a DataGrid (embedded into the parent form) with something like DataGrid.RecordSource = rst
Unfortunately, I can't seem to find a suiteable DataGrid control. Maybe I'm missing a reference somewhere???
Can someone offer a little help?
Thanks in advance. RH