Requery Subform (1 Viewer)

[raphael99]

Hi
I have one subform (subformname) that I would like to requery when updating with data another form (PipForm).
When I press a button which save data on (PipForm) i have setted this code:

Me.Parent.Subformname.Form.Requery

But get error that object is missing.
I have no idea how to update (subformname) after I have input data on (PipForm)

 

[fvdb]

Try Me.requery

 

[raphael99]

I tried the follow:

Forms![Mainformname]![Subformname].Form.Requery

But having the form which contain the form open nothing happen.
If I close the form containing the subform and Reopen it is there.
I would like to update the subform in realtime when saving PipForm button

 

[fvdb]

Instead of your code place this

DoCmd.Requery

It will refresh your form

You put your code in a sub onclick of the buttom?

 

[raphael99]

Update. I cannot run

Forms![Mainformname]![Subformname].Form.Requery

Beacuse it does not find the form

mainformname

 

[raphael99]

Instead of your code place this

DoCmd.Requery

It will refresh your form

You put your code in a sub onclick of the buttom?

I cannot Use Docmd.Requery because the button is on a third form (PipForm). I dont think it is the right way

 

[fvdb]

What are the name of the forms? Pipform is the form with the button

What is the name of the form with the subform you want to requery? What is the name of the subform?

 Forms!nameMainform!nameSubform.Form.Requery

should do the work

 

[Tieval]

Doing exactly the same thing I use the following VBA code as the last action of a button press on a completely separate form from the one where the requery is required:

Forms!frmPartsMain.frmPartsList.Requery

where frmPartsMain is the main form and frmPartsList is the sub-form within it.

This works perfectly for me.

 

[raphael99]

Tried both solution but it does not works.
It does not update. Tried also to refresh after requery but nothing happen. I can only close and reopen the form.
My code

Forms.Mainformname.Subformname.Requery

PIPForm is the form with button that should be Requery and update the Subform

 

[jdraw]

Suggest you post your database. (zip format)

 

[Tieval]

Forms!Mainformname.Subformname.Requery

not

Forms.Mainformname.Subformname.Requery

It is an exclamation mark after the forms, not a full stop.

 

[Minty]

The most useful of links for this http://access.mvps.org/access/forms/frm0031.htm
I have it bookmarked as I can't ever get it right first time.

 

[Tieval]

or alternatively you can spend half a day trying every possible option until it works like I did

 

[raphael99]

here it is : View attachment Db1.zip

 

[raphael99]

Forms!Mainformname.Subformname.Requery

not

Forms.Mainformname.Subformname.Requery

It is an exclamation mark after the forms, not a full stop.

I mistyped. sorry . Point or exclamation point it does not works

 

[Tieval]

Forms!FRMMesePrecedentePIP.[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Requery

I think you have put an underscore in to represent the space and you cannot do this, you need to keep the space and bracket the sub-form (I think). Also drop the .Form at the end.

In order to look at this properly people would need the backend database as well as the front end.

On a personal note I would shorten all my form, table and query names to small single items such as FRMsqpcrmp - that way you don't have issues with typing and bracketing.

 

[raphael99]

Yes in fact I put underscore for spacing. Anyway I have brackened as you suggest but nothing happen.
I have work_BE but that I built is an example exported database.
Thanks for your suggestion

 

[Tieval]

I hope you noticed I edited my previous response.

The DB1 that you sent still links to a _be and therefore is difficult to debug without it.

 

[raphael99]

I'm working on a splitted database named Work. The only BE I have is Work_BE.
I include it . But I don't know if it works because the Db1 I sent it is built for the forum and it is not split.
Anyway I upload also Work_BE
View attachment work_be.zip

 

[Tieval]

Forms!FRMMesePrecedentePIP.[FRMSottomaschera QueryPIPConcatRelatedsuMesePrecedente].Form.Requery

Ok, you still need to remove the .Form but the biggest issue is that FRMMesePrecedentePIP does not exist in the database, it does not get past this.