Is it possible to manipulate records in a wizard created subform.

[desgordon]

I have created a master-detail form in Access 2003 and now want to include a few command buttons to manipulate field values on the details form. I am very new to development using Access so please bear with what may seem some very simple questions:



1) Is this possible? When I attempt to insert a command button a series of screens appear which seem to lead to a limited set of options that the command button will be able to perform.

2) If the answer to 1 in yes, then could somebody point me to some example code where simple modifications on the detail recordset is performed.

[dcrake]

It sounds like you have the Wizard button disabled on your toolbar. whilst in design mode look at your toolbox and see if the Controls Wizard is enabled.It's like a magicians wand.

David

[desgordon]

Actually, the subform was already created. What I wanted to do was to manipulate values in the current record at the click of a command button but didn't know the object model for the subform. I figured it out last night though, so for the benefit of some other novice who may have a similar question:

Private Sub COMMAND_BUTTON_Click()
yoursubformname.Controls.Item(index).DefaultValue = yourvalue
End Sub