Thing won't allow me to requery

  • Thread starter Thread starter Stapes
  • Start date Start date
S

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
 
Stapes said:
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?
Click to expand...


Use

Forms![Purchase Order Form]![Order Details].Requery
 
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.
 
Back
Top