Super easy question

[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.

 

[Yair Sageev]

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.

 

[Hugh O'Neill]

You totally do Rule, I was just looking for the same thing
Thanks a million!

You're both welcome.

Hugh