How to correspond main form text box

[mithani]

Hi all,

I have one form with subform. In subform, i am doing datediff from two different dates, one text box from subform and other from main form. How can i correspond the main form text box in sub form. Like i have given code:

=([Week_ending_date]-(Form!job_costing_week_ending))*7

But not working. Please see the attached jpg.

thanks

mithani

 

[Banana]

The reference is incorrect.

Bookmark it. Use it. Love it.

 

[mithani]

Dear Banana,

Thanks for your reply. I have gone through your link and tried and tried but not suceed. would you please let me know the correct syntax?

thanks man

mithani

 

[Banana]

Just remembered one more thing you should make your bestest friend ever.

(This is off the top of my head so you may need to do some searching)

If you go to the control's properties, look up the record source property. There should be a button to right, which you can click on to bring up the expression builder. From there, you should be able to find the correct expression. Hint: Look in folder named "Loaded Form" to help you find the correct form.

Detailed instructions.

 

[mithani]

Thanks Banana.