subform referencing items

[kadams0920]

The attached database has a field that is calculating the dateDiff between today's date and the most current date on a subform. I can't get that working. On the form navigate to the Food Pantry tab, you'll see the calulated field called txtDaysElapsed. Can you please help me get this working?

Much appreciated!

Im having trouble attaching the database. Is there any reason why I may not be able to attach the file?

 

[stopher]

For help in uploading your database, take a look here

Chris

 

[kadams0920]

Thanks - file's attached.

 

[stopher]

The text box you are trying to reference is in a sub-sub-form (rather than just a sub-form). So the syntax should be:

=DateDiff("d",[Forms]![frm_Data_FoodPantry]![frm_Data_FoodPantry_Clients].[Form]![data_FoodPantry_DateServed].[Form]![DateServed],Now())

hth
hris

 

[kadams0920]

Ah, that's it. I didn't think about the subform within a subform. This is working fine now.

How do I make this a 'solved' post?

Thanks so much.

Karyn