reach control subform

[phpatrick]

Hi, I already review several posts but I could not find the right syntax.

situation
Mainform Form_Contact
Subform Form_Time
Control SHIFT1VAN in Subform

In the subform I have a button, when the user clicks the event onclick the current time 12.11 should set to the control of the subform.

Ive don it before, but can't find the right syntax anymore.

 

[phpatrick]

Forms!F_TIME!SHIFT1VAN = Now()

This works but when I am in this form, but I should reach this from the main form where this subform is in. How to ?

 

[phpatrick]

Forms![main form name]![subform control name].Form![control name]

 

[Remou]

From the main form, the syntax is:

1. [tt]Me.[/tt] or [tt]Forms![Name of Main Form].[/tt]
2. [tt][Subform Control Name][/tt]
Make sure this is the name of the subform control, not the form that is contained by this control. That is covered with a straight:
3. Form.
4. [tt][Control Name][/tt]

So, for the above, perhaps something like:

[tt]Me.F_TIME.Form.SHIFT1VAN = Now()[/tt]

See:

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

 

[PHV]

Another useful link:

http://support.microsoft.com/?kbid=209099

Feel free to play with the expression builder (loaded forms) to discover the name of your controls.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886