S
SUB
hi all,
Anybody know how to this?? I create a recordset which
allows the use of SQL, but then I need to force a form to
use this data (Bind it to the form).
Dim cmd1 As ADODB.Command
Dim rst1 As ADODB.Recordset
Set cmd1 = New ADODB.Command
With cmd1
.ActiveConnection = CurrentProject.Connection
.CommandText = "SELECT * FROM [mytable]"
End With
Set rst1 = cmd1.Execute
This opens a recordset, how can I then set bind this to
either a new or existing form???
cheers in advance for assistance
SUB
Anybody know how to this?? I create a recordset which
allows the use of SQL, but then I need to force a form to
use this data (Bind it to the form).
Dim cmd1 As ADODB.Command
Dim rst1 As ADODB.Recordset
Set cmd1 = New ADODB.Command
With cmd1
.ActiveConnection = CurrentProject.Connection
.CommandText = "SELECT * FROM [mytable]"
End With
Set rst1 = cmd1.Execute
This opens a recordset, how can I then set bind this to
either a new or existing form???
cheers in advance for assistance
SUB