Updating a form

[JonathanT]

I have Form A which is based on a table and Form B which is based on a query. Currently I have code written so when I change a certain field value in Form A it updates the records in Form B. I would like to embed Form B in Form A rather than have two forms open. When I embed Form B in Form A the code to update Form B doesn't run. The error is Microsoft Access can't find the referenced form 'Form A'.

Any ideas would be appreciated

[Welshgasman]

Well showing your code would be a start?

If B is embeded in A, then A is the parent and you could just use
Me.BControl = Me.Parent.AControl

However more than one record, implies and Update query perhaps?

[CJ_London]

see this link about how to reference forms and controls on other forms
http://access.mvps.org/Access/forms/frm0031.htm

[JonathanT]

The code I'm using to update Form B is "Forms!Form B.Requery" . The code is in the AfterUpdate property of a combobox field on Form A. It works as expected when Form A and B are open but not when Form B is embedded in Form A

[CJ_London]

you shouldn't need any code, just set the subform control linkchild/master properties - linkmaster will be the name of your 'certain field' and linkchild the related field in formB.

incidentally, when providing code, please make sure it is accurate as

"Forms!Form B.Requery"

won't work. Best to copy/paste

And do read the link I provided in post #3.

[JonathanT]

Thanks all. I'll review the suggestions

[JonathanT]

I'm going to restate my question. I may have been too vague. I have FormA which is based on the table 'Spending'.
FormB is based on a query 'Detailqry' and displays 3 fields from the query. FormA has code in the 'AfterUpdate' property of several combo boxes that requeries the 'Detailqry' for FormB when a combobox on FormA is updated.
The code is:
Private Sub MonthFilter_AfterUpdate()
Forms!FormB.Requery
End Sub
(MonthFilter is the name of a combobox on FormA)

The two forms work as intended when both are open. However when I embed FormB into FormA and update a combobox on FormA , I get the message "Microsoft Access can not find the referenced form "FormB".

Any ideas?

[Micron]

Error is because the syntax is wrong, which is based on the hierarchy of related objects. Use the syntax of one of the following:

Forms("MainFormName").Controls("subformControlName").Form 

Forms("MainFormName").Controls("subformControlName").Form

Either of those should get you to the subform level. After that, you either drill down further to form controls or just continue with form properties or methods. NOTE: subformControlName is the name of the control that contains the subform, which may or may not be the same name as the subform. Access has the tendency to name this the same, as well as name controls the same as the field they're bound to. Personally, I don't let that stand. Also, use your object names, not (e.g.) MainFormName.

[Welshgasman]

Take a read of this page

http://access.mvps.org/access/forms/frm0031.htm

[CJ_London]

That link already provided in post #3

[Welshgasman]

Perhaps the O/P might refer to it now as it has been repeated?

[CJ_London]

Don’t think the OP is reading anything provided, or failing to understand the basics

[JonathanT]

I've read everything more than once. As suggested I'm missing something basic to this process. I'm going to try to create a form and subform from scratch and see if the subform will act as intended. My current forms may have some code or relationship configuration that is preventing the desired result.

[Micron]

If you get stuck consider posting a copy of the db, or one that at least contains what's needed to replicate the issue. If your db is split, either post the back end (be) as well or just keep the form(s) and needed tables in a new version and post that. Usually you must zip your file in order to condense it enough to post here. If your data is confidential, consider https://www.accessforums.net/showthread.php?t=77482

Soon I will be on the road (then on the ocean) so my time here will be limited for about 2 weeks, thus will have to bow out after today.

[JonathanT]

Thanks Micron, Your post on the 20th was the answer. When I embedded the form I needed to change the name under the Property Sheet 'Selection type:subform/subreport' to a different name than what Access had chosen. I also changed the .Form to .Requery and now all functions work in the embedded subform