你的DBGrid是与Data控件绑定的吧?'点按钮1,把当前记录赋给Form2中对应的Text Private Sub Command1_Click() With Form2 .Text1.Text = Data1.Recordset(0) .Text2.Text = Data1.Recordset(1) .text3.Text = Data1.Recordset(2) '...... End With End Sub要关闭Form2时,把修改后的值写回DBGrid中:Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) With Form1.Data1 .Recordset(0) = Text1.Text .Recordset(1) = Text2.Text .Recordset(1) = Text2.Text '...... Data1.Recordset.Update End With End Sub
'点按钮1,把当前记录赋给Form2中对应的Text Private Sub Command1_Click() With Form2 .Text1.Text = Data1.Recordset(0) .Text2.Text = Data1.Recordset(1) .text3.Text = Data1.Recordset(2) '...... End With Form2.Show vbModal '以模态方式弹出Form2 End Sub
这段代码我试了。但是有问题弹出实时错误424。要求对象 望指教这里DATA1是哪个对象?
用Adodc绑定DataGrid的话,这样写'点按钮1,把当前记录赋给Form2中对应的Text Private Sub Command1_Click() With Form2 .Text1.Text = Adodc1.Recordset(0) .Text2.Text = Adodc1.Recordset(1) .text3.Text = Adodc1.Recordset(2) '...... .Show vbModal '以模态方式弹出Form2 End With End Sub'要关闭Form2时,把修改后的值写回DataGrid中:Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer) With Form1.Adodc1 .Recordset(0) = Text1.Text .Recordset(1) = Text2.Text .Recordset(1) = Text2.Text '...... .Recordset.Update .Recordset.Requery End With Form1.DataGrid1.Refresh End Sub
MsgBox Adodc1.Recordset.AbsolutePosition
End Sub
2.通过Sub DataGrid2_RowColChange中将关键列的值传递给全局变量;
3.在新窗体中以传递过来的关键字检索处数据
新窗口.text=adodc1.field(0)
....
Private Sub Command1_Click()
With Form2
.Text1.Text = Data1.Recordset(0)
.Text2.Text = Data1.Recordset(1)
.text3.Text = Data1.Recordset(2)
'......
End With
End Sub要关闭Form2时,把修改后的值写回DBGrid中:Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
With Form1.Data1
.Recordset(0) = Text1.Text
.Recordset(1) = Text2.Text
.Recordset(1) = Text2.Text
'......
Data1.Recordset.Update
End With
End Sub
Private Sub Command1_Click()
With Form2
.Text1.Text = Data1.Recordset(0)
.Text2.Text = Data1.Recordset(1)
.text3.Text = Data1.Recordset(2)
'......
End With
Form2.Show vbModal '以模态方式弹出Form2
End Sub
望指教这里DATA1是哪个对象?
Private Sub Command1_Click()
With Form2
.Text1.Text = Adodc1.Recordset(0)
.Text2.Text = Adodc1.Recordset(1)
.text3.Text = Adodc1.Recordset(2)
'......
.Show vbModal '以模态方式弹出Form2
End With
End Sub'要关闭Form2时,把修改后的值写回DataGrid中:Private Sub Form_QueryUnload(Cancel As Integer, UnloadMode As Integer)
With Form1.Adodc1
.Recordset(0) = Text1.Text
.Recordset(1) = Text2.Text
.Recordset(1) = Text2.Text
'......
.Recordset.Update
.Recordset.Requery
End With
Form1.DataGrid1.Refresh
End Sub