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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Retain control in a popup 4
OpenArgs Questions 4
Subform with subform properties 0
BeforeUpdate doesn't always fire 15
Command button to close and return to original form 2
Subform question 5
VBA Syntax for subform record source change 6
Goto new record of subform and force a save using the default values ? 1

Back
Top