unbound recordset with ADP project

  • Thread starter Thread starter Boazs
  • Start date Start date
B

Boazs

Hi
Im trying to use a temp recodset in a muti user
env a tried to build the recordset and then to
attach it to the form but it did not work
(with no err msg at all) the code i used

Dim rst As ADODB.Recordset
Dim cnn As ADODB.Connection

Set rst = New ADODB.Recordset
rst.Fields.Append "TakeoffNo", adVarChar, 255
rst.Fields.Append "ItemNo", adVarChar, 255
rst.Fields.Append "ItemRev", adVarChar, 255
Dim i As Integer

rst.Open

For i = 1 To 5


rst.AddNew
rst.Fields("TakeoffNo").Value = "aa"
rst.Fields("ItemNo").Value = "bb"
rst.Fields("ItemRev").Value = "cc"
rst.Update

Next

Set Me.Recordset = rst
Me.TakeoffNo.ControlSource = "TakeoffNo"
Me.ItemNo.ControlSource = "ItemNo"
Me.ItemRev.ControlSource = "ItemRev"

Thanks
Boaz
 
Have you done a search, or read something, that indicated
you can do what you want? I am not aware that it is
supported.

There is support for a "disconnected recordset" as
RecordSource for a Form. ADO is, in fact, a way to
communicate with databases, not to handle any kind of
recordset (though the definition of "database" in ADO is
broader, by far, than in DAO).

Perhaps you could look into "local XML tables" as an
alterntive.
 
Back
Top