Thing won't allow me to requery

[Stapes]

Hi
I have a form Purchase Orders with a subform Purchase Order Items.
When I add prices into the Purchase Order items subform, I want the
main form to requery to display the new totals. I use this:

Forms.[Purchase Order Form]![Order Details].Requery

I get run-time error '438'.

Object doesn't support this property or method.

What is wrong with the thing?

Stapes

 

[Dirk Goldgar]

Hi
I have a form Purchase Orders with a subform Purchase Order Items.
When I add prices into the Purchase Order items subform, I want the
main form to requery to display the new totals. I use this:

Forms.[Purchase Order Form]![Order Details].Requery

I get run-time error '438'.

Object doesn't support this property or method.

What is wrong with the thing?

Use

Forms![Purchase Order Form]![Order Details].Requery

 

[Pat Hartman]

Use:
Forms![Purchase Order Form]![Order Details].Form.Requery

You need to replace the first dot with a bang. You then need to follow the
subform name with .Form to indicate that you want to use a form method.
Leaving out the .Form may work but shorthand omissions can come back to bite
you when you convert to new versions of Access.