Update Data from a Main form to a subform

[mattc66 via AccessMonster.com]

I want to update data from my main form using a button:

MainForm1 TextFld1

To

Subform1 TextFld1

How would I type the code?

 

[Guest]

Try

Forms!MainForm1!Subform1.Form!TextFld1 = Forms!MainForm1!TextFld1

Trev

 

[mattc66 via AccessMonster.com]

Should I have a Me.Forms? It doesn't seem to be working?

Try

Forms!MainForm1!Subform1.Form!TextFld1 = Forms!MainForm1!TextFld1

Trev

I want to update data from my main form using a button:

[quoted text clipped - 5 lines]

How would I type the code?

 

[Guest]

You can use me but if you do it must be

Me.Subform1.Form!TextFld1 = Me.TextFld1

there is no reason why my previous code is not working. Check the following
first:-

Check that the subform is actually names Subform1 (Make sure no trailling
spaces or other chrs)

Do the same for your two text boxes if it still does not work use the
following to find out which one of the two is faulty.

Forms!MainForm1!Subform1.Form!TextFld1 = "Message for subform is ok"
Forms!MainForm1!TextFld1 = "Meaages for main form is ok"

Trev

Should I have a Me.Forms? It doesn't seem to be working?

Try

Forms!MainForm1!Subform1.Form!TextFld1 = Forms!MainForm1!TextFld1

Trev

I want to update data from my main form using a button:

[quoted text clipped - 5 lines]

How would I type the code?

--
Matt Campbell
mattc (at) saunatec [dot] com

Message posted via AccessMonster.com