MS Access Combobox to Disable Controls on a Separate Form

in form2  change
"Me.Textbox.Value "

with

Forms!Form1.Textbox.value

Thx for your quick response Rey.  Now I'm getting run time error 2450 - cannot find the reference Form1 (and yes, I substituted Form1 with the name of my 'Form1' where the combo box resides).  Should I put something in the After Update event of Form 1 for Form 2?

Is there a way to make this private?  It's client confidential.

@ Rey.  As I got thinking about it - I'm nervous about sending actual code (which would reveal the client's name) without having you sign a confidentiality/non compete agreement with the litigious land we live in :/

@ Pat. The requests of the client are making this database complex.  Forms 1, 2, and 3 have the same controls at the top (sadly a tabbed single form was not an option):

cboSerial: [u]Serial#[/u]   txtDetail: [u]Description[/u]    txtDate: [u]DateofEntry[/u]
(^ = Combobox in my code above)

The user can choose a Serial # from Combobox/cboSerial on Form 1 and it will:
- Auto-populate the Description and DateofEntry boxes at the top of Form 1 and auto-populate Serial#, Description, DateofEntry  boxes at the tops of Forms 2 and 3
- Go to associated subform record on the same form
- Disable certain controls on Form 1 if Serial # ABC is selected (using After Update on the combobox)
- AND the final component on which I'm working, disable certain controls on Forms 2 and 3 since the header auto-populates with the same Serial#/Description/DateofEntry

I figured it out (sometimes I just need the experts to ask questions when I get stuck so I can work through it)

The Current event didn't like this part of the formula (highlighting ctl.Enabled = True w/ the 438 error):
[code]If Me.Combobox.Value = "Item1" Then
     For Each ctl In Me.Controls
         ctl.Enabled = True
     Next ctl[/code]

so I rewrote the formula like this and pasted it in the After Update of Combbox/cboSerial and Current Form of all 3 Forms:
[code]If Me.Combobox.Value = "ABC" (or Item2 above) Then
     For Each ctl In Me.Controls
          If ctl.Tag = 1 Then
               ctl.Enabled = False
          End If
     Next ctl
Else
     For Each ctl In Me. Controls
          If ctl.Tag = 1 Then
               ctl.Enabled = True
          End If
     Next ctl
End If [/code]

I don't know why it won't work w/out ctl.Tag in the Current event and doesn't need it in the After Update event for "Item 1," but now it works like a charm.  The user can select the Serial # from any of the 3 forms and when it hits ABC, certain controls are disabled on the current form and disables certain controls on Forms 2 and 3 when the user switches to them.

I'll give you both points for helping me out.

you should have accepted your last post as the answer.

The last time I did so and tried to assign myself a portion of the points, EE grilled me as to why I answered my own question and was giving me grief about assigning myself points.  (I guess it could be a way some people cheat?)  I don't really care about the points.  I just care about getting my projects done (and if someone has the same question, they can scroll through and find it at the end :)

You can always choose one of your own posts as the answer.  You just can't assign yourself any points for obvious reasons.

At least you have something you think works but "Forms 1, 2, and 3 have the same controls at the top (sadly a tabbed single form was not an option)" isn't an answer to the question "Are you trying to disable the controls on Form2 from code running in Form1?  "  It is a non-sequitur.

Just FYI, if you are going to have multiple forms open at one time, the best technique is to hide all but one or make the active form Model so the user can't type in any other form until the model form is closed.  Then if you need data in a model form that originates in the calling form, "pull" it by having form2 get the values from form1.  Do NOT "push" the data from form1 to form2.  "pushing" causes you to dirty the record in form2 and that is poor practice since it leads to confusion for the user and leads to incomplete records being saved if you are not careful with your validation.

Thx Pat - good to know.  Just giving the big picture in my response.  Only one form is available to the user at a time (even though technically all three are open)

Cheers!