Getting a value from another form

[UT227]

I need to get a value from another form. I'm still working on learning VBA. Here's the error and my code.

[isladogs]

Try Forms!frmMainMenu.UserID

[UT227]

Awesome! Thanks. Worked great. I put that extra "me." in it.

[UT227]

I have one more like it. I have a value in a subform [frmWeaponsSubF] and want to populate the field [ReturnedByID] with the same information as the previous. Here's what I get.

[UT227]

I just got it.
Me.frmEquipReturnSubF!ReturnedByID.Value = Forms!frmMainMenu.txtUserID

I'm learning

[isladogs]

If its in a subform, you should use this:

Me.frmEquipReturnSubF.Form.ReturnedByID = Forms!frmMainMenu.txtUserID

NOTE .Value isn't needed as it's the default for controls

See this link for more info on referencing subform controls: http://allenbrowne.com/casu-04.html

[UT227]

That worked perfectly. Thanks.