Update Data from a Main form to a subform

  • Thread starter Thread starter mattc66 via AccessMonster.com
  • Start date Start date
M

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?
 
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



mattc66 via AccessMonster.com said:
Should I have a Me.Forms? It doesn't seem to be working?

Trever said:
Try

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

Trev
I want to update data from my main form using a button:
Click to expand...
[quoted text clipped - 5 lines]
How would I type the code?
Click to expand...
Click to expand...

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

Message posted via AccessMonster.com
Click to expand...
 
Back
Top