Requery specific field on continuous form (for all records)

[TUSSFC]

I have a continuous form which will only ever have 3 records.

I have a command button which executes some code that changes the values of a specific field in all 3 records. I need the form to update to show the correct values after this change.

However ... I can't close/reopen the entire form or requery the entire form.

So i'd like to requery the specific field - but ensure this field on ALL records are requeried.

I tried:

Forms!frm_Daily!Validations.Requery

but get this error:

"Run-time error 3188 Could not update, current locked by another session on this machine"

Any ideas? :-s

 

[Banana]

I do not think the Requery method can work for a specific fields. I think you may be able to do so with Refresh method, but I'm not sure if that is the right correct.

That said, does your code modify the continuous form's recordset directly (as opposed to updating the source tables)? If it does, then there would be no need to requery.

 

[missinglinq]

Why can't you requery the entire form?

 

[TUSSFC]

Why can't you requery the entire form?

The form is based on a parameter query which gets its criteria from another forms text fields.

So ..

Form1 - text field where a date is picked
Form2 - bound to a query which selects its records using what was selected on Form1

If I requery the whole form it loses the value from Form1 and can't return the correct recordset.