Hello I will be so thankful for help on this: I am trying to use one form that will change according to who accesses it. I am using an ADO and a datagrid on the form. So I am trying to change the recordset for the ADO at runtime. Everything I have found says to use the following code but it will not REFRESH. Any help or suggestions on how you changed your ADO recordset at runtime. Thanks Much.



Private Sub Form_Load()
Dim strquery As String

With frmSkipGAFL.Adodc3
.Mode = adModeReadWrite
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=S:\DBAPPS\Repo\RepoInv.mdb"
.CommandType = adcommandtext
End With

strquery = "SELECT * FROM RepoInventory WHERE RepoStatusID = 12"
Adodc3.RecordSource = strquery
Adodc3.Refresh

End Sub