Insert data from subform textbox into parent form textbox? 2

[tylerwork]

I have in a subform a textbox that has info in it. I have a button that I want to click, and automatically populate a textbox in a text box in the parent form. Don't ask the reason, it's how the user wants it!

what line of code will work with this?

I have this but it isn't working:

Me!Inst_By.Value = Me!Forms.Search_Inventory.Installed_by.Value

 

[essnrv]

Try this
Me!Inst_By= Me!Forms![Search_Inventory]!Form![Installed_by]

 

[JeremyNYC]

Refer to things on subforms like this:
forms!NameOfTheMainForm!NameOfTheControlThatHoldsTheSubform.Form!NameOfControlOnSubformYouWantToReference

"Forms" and "Form" should be in there literally. You have to refer to the name of the control that holds the subform, which may or may not be the same as the name of the subform. I make sure they're always named the same thing, but that's a personal preference thing.

Taking this into account, you'd want to do this:
Me!Inst_By.Value = Me!Search_Inventory.form.Installed_by.Value

Jeremy

PS: Why does the user want this? Really, I'd be interested to hear why. It sounds like you already know it's a weird thing to do, but I'm always curious to learn about users.

=============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[tylerwork]

Thanks! and if I want a button in a subform to turn EDITS ON in the parent form, how do I do that?

Me!Forms![Search_Inventory]!Edit = True

that doesn't work

 

[tylerwork]

Actually neither of those work. Hmm... .says the form name isn't valid

 

[essnrv]

Me!Forms![Search Inventory].Form!Edit = True

 

[tylerwork]

With all of these, it keeps telling me that it can't find the FIELD: "Forms"

Keep in mind that the button I am using is in the Child_Subform, while the location of the actions I want to take is in the Parent_Form.

 

[essnrv]

Sorry,It was wrong
Forms![Search Inventory].Form!Edit = True

 

[tylerwork]

nope, that didn't work either. AGHGHGHG! Frustrating

 

[JeremyNYC]

Isn't that "AllowEdits", and not "Edit"?

Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.


Remember to reward helpful tips with the stars they deserve.

 

[essnrv]

What is your control name and type ?

If it is a Check box then

Dim FormName as Form
Set FormName=Forms![Search Inventory].Form
FormName![Edit]=-1 'Checked 0 for Unchecked

 

[tylerwork]

Got it! it was AllowEdits. DUH thanks everyone!!!

 

[JeremyNYC]

Forms![Search Inventory].!AllowEdits = True =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995

http://www.AlphaBetCityDataworks.com

Take a look at the Developer's section of the site for some helpful fundamentals.