Updating Navigation subform from another form

[MHutcheson]

Hi all,

I'm using Access 2010 and need to update a sub form in a form that is within a navigation form. So it goes:

Navigation Form > Main Form > Subform

How do I do this? I've attatched the following to a click event of a cmd button but I just can't get it to work:

Forms!frmMain.NavigationSubform.Form.frmJobHeadSubForm.Requery

Where am I going wrong?

Regards,

Michael

 

[pr2-eugin]

Where is this command button placed?

 

[MHutcheson]

Hi Paul,

It is located on another pop up form.

Regards,

Michael

 

[pr2-eugin]

Try this.

Forms!Mainform!Subform1.Form!Subform2.Form.Requery

 

[MHutcheson]

I've tried this:

Forms!frmMain!NavigationSubform.Form!frmJobHeadsubform.Form.Requery

But it says it cannot find 'frmJobHeadsubform'

Check spelling and it is correct...

 

[pr2-eugin]

Try using the Expression builder. It makes referencing much easier.

 

[MHutcheson]

Ah yes, but you can't access the expression builder from VBA in Access 2010

 

[pr2-eugin]

Yes, get what you want from the expression builder then paste it into VBA

 

[MHutcheson]

When I use the expression builder and drill down loaded forms etc, it just displays a blank window in Expression Categories.

 

[pr2-eugin]

Can you post a sample DB?

How to Upload a Stripped DB.

To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[MHutcheson]

I got this to work. If anyone is interested, to requery a subform when used in a form that is in a navigation form use:

Forms("ActualNameOfMainNavigationSubform").Form("NavigationSubform").Form.whateveryouaretryingtoaccess

Credit to the person who solved it:

http://answers.microsoft.com/en-us/...e4-8bdf6852af13?page=2&rtAction=1392301455037

Regards,

Michael