ADO code generated recordset and binding to form controls

ADO code generated recordset and binding to form controls

Post by Shirley Lander » Thu, 27 Apr 2000 04:00:00

I have a recordset generated totally in code.  I want to bind the data to
objects on a form.  I don't want to bind each textbox and combobox manually
in code (too many of them!). Don't want to use only datacontrols - too much
overhead and performance loss with each datacontrol making it's own
connections etc.

I am feeding the coded recordset to a datacontrol which then handles binding
to the form controls.  I am feeding the recordset to the data control by
setting (in code for run time) the datacontrol's recordsource property to my
code recordset.

adodc1.recordsource = rs1

From the books and help etc.  it looks like this should work.  It only kinda
works for me.  Labels and textboxes do correctly populate their data, but my
comboboxes are empty.

Any help?


1. Calculated controls in Access Form bound to ADO recordset

I can't get calculated controls to work with Access 2002 when the form is
bound to and ADO recordset.

For example a textbox with ControlSource =Sum([OrderQty]) where  [OrderQty]
is a field in the form recordset
*     works OK if the form is bound to an identical recordset from an Access
query and shows the total OrderQty
*    always give #Error if form is bound to an ADO recordset




tel        01223 514674 (Cambridge)
mobile  07970 161057
fax        07970 601283

This communication is for the attention of the named recipient only
The content should not be passed on to any other person.
It is sent in good faith, in confidence, and without legal responsibility.

Emails and attachments are virus checked using Norton? AntiVirus?
2002 which is regularly updated. However  it remains the recipients
responsibility to check emails and attachments sent, or forwarded,
from for viruses and macro viruses

2. How to include numerating column for selecting rows

3. Bind an ado recordset directly to an ado data control (adodc)

4. Arizona Oracle Contracting?

5. Binding a control to a recordset defined by code

6. Implicit Conversion Error

7. Binding controls to ado code

8. Error 91 when trying to bind an ADO Recordset to an MSFlexGrid Control

9. Changing the source on an ADO recordset bound to controls

10. Bound controls not updating ADO with adodc.recordset.update command

11. bound ado controls and form initialization

12. VB6 - ado - binding form controls to database