Is there a way to bind all my controls in a program once, at the moment I am having to rebind them every time I move or alter records which is getting slower as I add more controls to the form.
My current code is something like :
For Each fctrl In frmInstMain.Controls
If (TypeOf fctrl Is TextBox) Or (TypeOf fctrl Is Datacombo) Then
Set fctrl.DataSource = Nothing
Set fctrl.DataSource = DataEnvironment
End If
Next
The recordset and datafield of each control are set at design time.
Again any input would be much appreciated.
My current code is something like :
For Each fctrl In frmInstMain.Controls
If (TypeOf fctrl Is TextBox) Or (TypeOf fctrl Is Datacombo) Then
Set fctrl.DataSource = Nothing
Set fctrl.DataSource = DataEnvironment
End If
Next
The recordset and datafield of each control are set at design time.
Again any input would be much appreciated.
