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
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