Show Valuees from Subform in MsgBox

[Ossos]

I received this Run-time error 2465 " MS Access can't find the field "3_FAcrRoomSubForm" refered to in your expression" every time run "CmdFacRoomEdit"



The Attached File illustrate the complete syntax

I want the MsgBox for a value of MedFacRoomNo (Named in Other Tab as "TxtRoomNo") in the SubForm 3_FacRoomSubForm but...

Regards

[jwhite]

Please verify that the actual Name of the Subform Control on the Main Form is as referenced in your code. Looks like it has an extra r before Room.

[Ossos]

I check everything, that is why I sent a snap shot from my screens,

[aytee111]

Remove the ".Form"

[jwhite]

Posting an image isn't helping us that much... The error message quoting "3_FAcrRoomSubForm" means you have that erroneous value stated somewhere. Please post a copy of your database with confidential data removed.

[John_G]

In the MsgBox Forms!..., use the name of the Control, not the name of its record source:

Forms![3_FacRommMainForm]![3_FacRoomSubForm].Form!txtRoomNo

[Ossos]

I am afraid that, I am still receiving the same error

[jwhite]

I understand, but you need to tell us what you have actually done with our suggestions, or provide the database as requested. What I am referring to is highlighted in the screenshot attached. You will notice that the "Source Object" name (stored form name) is DIFFERENT from the "Name" name. In this case my Forms statement would have frmArticleDetails instead of frmArticles_Subform.

[John_G]

On your main form, what is the name of the control that contains the subform? Not the name of the subform - the name of the control.

[orange]

Also, you could post a copy of your database (in zip format)?