Popup calander problem

[roccoau]

I have a popup calendar which works perfect on my form but will not work in an imbedded sub form.
If I go to the sub form itself it works perfect both in datasheet view and Form view. But if I go to the main form which this same sub form is imbedded (datasheet view) it does not work. The calendar appears on double click but date does not update when clicked.
The code in on dbl click is =opencalendar("")
Anyone know what I am doing wrong please ?
Rgds Roc

 

[boblarson]

I suspect that the update code, that references the subform in the popup calendar to update the field that you are wanting the date entered into, is not using the correct syntax.

Remember, to set a value on a subform via code, the syntax is:

Forms!YourMainFormNameHere.YourSubFormNameHere.Form.YourTextBoxNameHere

(**IMPORTANT NOTE** remember that the part above that says "YourSubFormNameHere" actually refers to the name of the control on the Main form that contains the subform.)

I'm guessing that you used something like:

Me.YourTextBoxName

and if you are bringing it up within the main form (even though it's on the subform) Me would refer to the main form.

 

[roccoau]

Thanks for your help BL