carled
asked on
VB 6.0 datagrid of detail record in master/detail form - adding new row issue
Doing a quick & simple VB 6 app that uses a form done by the data form wizard using ADO connection to SQL server. All works fine and I can add new rows...
It's just that when I click on the new row box of the data grid and add data, when I've finished entering the data on the row.. the only way I seem to be able to commit the row to the database is by using the master recordset navigation controls at the bottom of the form, stepping to previous record. This appears to update the database, but is a bit clumsy. Is there any way of having an "update" button for the detail record (it's a child recordset of a shaped recordset) alone?
It's just that when I click on the new row box of the data grid and add data, when I've finished entering the data on the row.. the only way I seem to be able to commit the row to the database is by using the master recordset navigation controls at the bottom of the form, stepping to previous record. This appears to update the database, but is a bit clumsy. Is there any way of having an "update" button for the detail record (it's a child recordset of a shaped recordset) alone?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the grade and if you have any issue with doing it this way, you know where to ask,
Leon
Leon
ASKER
Points to you for having the chutzpah for saying it though... ;-)