Question:
We want to use multiple VB forms with independent controls bound to independent data controls accessinga single table.In Vb 3.0, we are not able to save the controls dataof a datacontrol in a form FROM ANOTHER form.IS it actually possible to commit the changes of differentdatacontrols across forms.
Answer:
VB 4.0 data controls can have their recordset properties set programmatically, which is a change from VB 3.0. This feature will probably alleviate your problem, since you can set one data control’s recordset equal to another, regardless of which form it is on.However, the OLE server has to be in process for it to work correctly. This is a known “feature”, by design according to Microsoft.