Thing won't allow me to requery

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Stapes - 21 Jan 2008 17:07 GMT

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

Reply to this Message

Dirk Goldgar - 21 Jan 2008 17:30 GMT

> Hi
> I have a form Purchase Orders with a subform Purchase Order Items.
[quoted text clipped - 8 lines]
>
> What is wrong with the thing?

Use

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

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message

Pat Hartman - 21 Jan 2008 19:23 GMT

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.

> Hi
> I have a form Purchase Orders with a subform Purchase Order Items.
[quoted text clipped - 10 lines]
>
> Stapes

Reply to this Message