Refresh Sub Form Value

[Bartman]

Hi,

I have a main Form called "Audit_questions_(Part_1)" and it is linked
to a sub form via parent child links to staff names.

Basically the sub form is a query on the table that the main form
produces e.g. provides scores per question. The sub form totals the
scores achieved.

This works if I switch from main view to design view and back on the
form e.g. the total re-calculates the scores. So I need to refresh the
subform to do this automatically.

I used the code for the Current action:
Forms!Audit_questions_(Part1)!Score1.Form.Requery

Main form is: Audit_questions_(Part_1)
Sub form is: Score1

This code does not seem to work at all???

Bartman

 

[Arvin Meyer [MVP]]

The syntax appears correct. I suggest you try using square brackets around
the elements, as the parenthesis may be causing Access not to evaluate
properly:

[Forms]![Audit_questions_(Part1)]![Score1].Form.Requery

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access