How to view records in recordset in Access datasheet view using VBA code

Hi all,

My requirement is - when a user fills in some date in Text boxes, and clicks a button, I use that data to create an SQL select query, execute it and store it in a recordset object.

I am able to retrieve the records and show them in the Debug window as follows

' Open a Recordset object.
recordset.Open Source:=strSQLFind, _

' Display the records in the Debug window.

Do While Not .EOF
For Each fld In .Fields
Debug.Print fld.Value & ";";
Next
Debug.Print
.MoveNext
Loop


Instead of printing on the Debug window, I want to view the records of recordset object in datasheet view.(so that the users can modify the values of the selected records)

So, could anyone please suggest me a way to do so.