<div>
Thought that might be the case... &nbsp;Already settled on this as I needed it doing quickly!<br />
<br />
Points to you for having the chutzpah for saying it though... ;-)<br />
<br />

</div>


Thought that might be the case...  Already settled on this as I needed it doing quickly!

Points to you for having the chutzpah for saying it though... ;-)



<div>
Thanks for the grade and if you have any issue with doing it this way, you know where to ask,<br />
<br />
Leon
</div>


Thanks for the grade and if you have any issue with doing it this way, you know where to ask,

Leon

<div>
<div class="content wysiwyg-content">
Doing a quick &amp;&nbsp;simple VB 6 app that uses a form done by the data form wizard using ADO connection to SQL server. &nbsp;All works fine and I can add new rows...<br />
<br />
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. &nbsp;This appears to update the database, but is a bit clumsy. &nbsp;Is there any way of having an &quot;update&quot; button for the detail record (it's a child recordset of a shaped recordset) alone?
</div>
</div>


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?

VB 6.0 datagrid of detail record in master/detail form - adding new row issue

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.