UtterAccess Discussion Forums > Refering to another Form's subForm

Full Version: Refering to another Form's subForm

UtterAccess Discussion Forums > Microsoft® Access > Access Forms

dashiellx2000

Sep 30 2005, 12:38 PM

I have a main form with a subform. When the user clicks a check box stating that a letter was sent, a pop-up form opens asking them which letter was sent. The control on the pop-up form is a combobox. On the after update event of the combobox, I want a control on the Main Form's subform to take place. How do I refer to this control.

I've try:

[Forms]![frmAwaitingMRDetail]![Form]![sfrmFollowup]![NewDenialCodeID] = Me.Letter

and

[Forms]![frmAwaitingMRDetail]![sfrmFollowup]![Form]![NewDenialCodeID] = Me.Letter

But I get Run Time error 2465, that Access cannot find the field "Form" in my expression.

What is the proper syntax to use.

Thanks.

MattJ

Sep 30 2005, 12:55 PM

Try
[Forms]![frmAwaitingMRDetail]![sfrmFollowup]![NewDenialCodeID] = Me.Letter

freakazeud

Sep 30 2005, 01:17 PM

Actually I think it should be:

Forms!frmAwaitingMRDetail!sfrmFollowup.Form!NewDenialCodeID = ....

HTH
Good luck

dashiellx2000

Sep 30 2005, 01:23 PM

Thanks Matti, that worked.

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.