Click to See Complete Forum and Search --> : ADO Data Repeater and adding Records


Roy
June 2nd, 1999, 07:55 PM
I'm creating a database form using ADO. I've got a parent form and I'm uging a datarepeater as a child form. I can display data easily and all the data I have on the child table in MS Access displays in the datarepeater.

Can anyone give me the code which can be used in a command button to add data from the keyboard to the datarepeater function.

Jan Businger
June 3rd, 1999, 02:13 AM
I checked the MS VB6.0 Component Tools Guide for the Data Repeater Control (DRC).
No mention is made, that you can add data to the data base through the DRC directly. You can VIEW data which are already in the data base.
To ADD data, you use the I/O Form which you probably have got in yr application.
Hopefully this helps.


Jan

Roy
June 3rd, 1999, 07:58 AM
If I bind a data repeater to an ADO data control, I can add a new record by setting the EOF to Add New or by having a command button. The problem I have is that I am new to ADO and having a parent/child form uses only one data control rather than the two that we use in DAO.

The alternative is to use two data controls as with DAO for a parent/child form. Trouble is no book gives me a way of doing this. Can someone help.