Dot . Bang ! problem

[Mgomp]

Hi All.

While waiting for the big evening... I have a little problem with adressing a field in a another form;

I have a NavigationForm which is the main form with the new Access 2010 navigation buttons. On the TopText Form area I have two fields; Field1 and Field2.

One of this button navigates to a subform Subform. In ths subform I have some fields - lets say Field3 and Field4.
On this Subform I also have a command button which save the active record in the subform. This button should also update the value in field Field1 and Field2 with the values from Field3 and Field4 (From subform to mainform..?) All fields are standard text fields.

How do I adress the Field1 and Field2 in the NavigationForm from inside the Subform? (cmdUpdate -> OnClick event)

I have serious problem with this . and ! and some [] and where to put what...

Anyway,
Thanks for all god help I have found in this forum. And for all: Merry Christmas and a Happy new year!

 

[spikepl]

http://www.mvps.org/access/forms/frm0031.htm

 

[Uncle Gizmo]

This thread may provide inspiration...

http://www.access-programmers.co.uk/forums/showthread.php?t=202956

 

[missinglinq]

...should also update the value in field Field1 and Field2 with the values from Field3 and Field4 (From subform to mainform..

You've been given links to, I assume, sites explaining how to reference controls on main forms/subforms, but the question that I think needs to be asked here is "Why?"

Storing a single piece of data in two different places, unless you're talking about a Primary Key/Foreign Key, generally indicates incorrect database design. And using data from controls on a subform to populate controls on a main form is the opposite of the way things are normally done. What exactly is the purpose here?

Linq ;0)>

 

[Mgomp]

but the question that I think needs to be asked here is "Why?"

What exactly is the purpose here?

Linq ;0)>

Well, If I was talking about storeing values in tables I would be agree with you. I was talking about referencing fields in onther window/forms. Wich the two other replies where very helpfull.

I hope this will answer your "Why?"

Regards,

 

[vbaInet]

... about the [], you use them if your objects or field names contain one of these characters:


[FONT=arial, helvetica] ,.~!@#$%^&*()+-=|\:;'<>?/"`[]{} space[/FONT]