Super easy question

  • Thread starter Thread starter Yair Sageev
  • Start date Start date
Y

Yair Sageev

What is the command in VB to manually force a record to update?
Recordset.fields.update gives me an error, as does Me.recordset.update.

I have a button in the detail section of a continuous subform which opens a
pop-up form. Just before the OpenForm statement in the button's event
handler I'd like to force current row to commit to the database prior to
opening the form.

Much thanks.
 
Hugh, you rule. Thanks.

It turns out I need this line of code because when I click on the pop-form
button the data in the record is not committed before the pop-form is
opened. As a result, a foreign key in the pop-form is not available from
the parent.

It is now.
 
Back
Top