Editing SubForm Data From Main Form!

[vdanelia]

Hello Need your help.
I want to edit, add, delete data of sub-form field (it Is a Memo Field) from main table...

Please Help!

 

[randompherret]

add the memo to your main form query (or make it unbound from the main form and just bound to the memo query) and then on an after update event use requery on the subform control.

 

[vdanelia]

My Main form is based on Table not query, I created unbound-text box, i created a memo query, how to set that query to unbound text box as control source

 

[randompherret]

use the builder in the control source of it.

 

[vdanelia]

I did this but saying error "#Name?"

 

[vbaInet]

Hello Need your help.
I want to edit, add, delete data of sub-form field (it Is a Memo Field) from main table...

Please Help!

Could you please elaborate.

 

[vdanelia]

Hello VbaInet

I have a sub-form on the main form it is OK, but I needed that on my main form to be displayed one field from a sub-form "PcInfo" and that i could it edit (delete, add or edit values there: there are only PC component names)
Then I created unbound text box, created a query, set it as control source, but not works
I think that I'm doing something wrong

 

[vbaInet]

Why do you have to put it on your main form?

Is your subform in Datasheet view?

 

[vdanelia]

Mu sub form is "Continuous Form"
I'm adding it because it is very comfortable to edit pcinfo from main table, in the future i can show or hide it by a command button.

 

[vbaInet]

Why don't you put it in the Header or Footer section of your subform?

 

[vdanelia]

Because of My form design......
I did it (=[SForm].[Form]![PcInfo]) Displaying everything as needed, but can't edit the field

 

[vbaInet]

If you put it in the Header section of the SUBFORM, you just need to set the Control Source as [pcInfo]

 

[vdanelia]

On the sub-form it works perfectly, but I needed it on my Main form..
Is it difficult to solve that problem, I tried many variants,but none of them worked

 

[vbaInet]

Is it difficult to solve that problem, I tried many variants,but none of them worked

I didn't say it's difficult I'm just trying to make you think of other ways of working.

In the AfterUpdate event of the textbox that is in the subform and in the On Current event of the subform, do this:

Me.Parent.MainTextboxName = Me.PcInfo

where MainTextboxName is the name of the textbox in the main form.

In the After Update event of the textbox that is in the main form, do this:

Me.SubformControlName!PcInfo = Me.MainTextboxName

where SubformControlName is as the name implies.

 

[vdanelia]

Greatest Thanks vbaInet
Works perfectly
You're Super

 

[vbaInet]

You're welcome vdanelia!

 

[vdanelia]

Hello vbaInet

I noticed something strange:
Everything is working perfectly, but when I'm opening the sub-form it says: Run-Time Error '2452' Expression you Entered has invalid reference to that parent property

 

[vbaInet]

That's because your subform loads before the main form and Parent (in the Current event) refers to the main form but at this time it hasn't loaded and thus can't be found. So what you need to do is this:

1. In the property sheet of the subform, remove the word [Event Procedure]. Don't touch the code behind it, leave it as it is.
2. Save and close the subform.
3. In the Current event of the main form put this:

Me.SubformControlName.OnCurrent = "[Event Procedure]"

Done!

There's another way, but I prefer this one.

 

[vdanelia]

Hello vbaInet
I did it and now opening the sub-form without any error
Thanks a lot

 

[vbaInet]

Good job vdanelia!