Evaluation Notice (1 Viewer)

[burrina]

frmEmployees is the Main form.
txtcurdte is the Current Date


TPayRate is a Subform where their Last Raise Amount is stored.
PayEffDate is a Date Field for the last time a raise was given.On the subform

Example: ? Refer to subform from frmEmployees
[TPayRate].[Form]![PayEffDate]
DateDiff("d",[PayEffDate],[txtcurdte]) 'Almost ? Max ?

txtdayssinceraise = How many Days since last raise.

 

[richsql]

Not sure what the problem is are you looking for the method of referencing your the control on your subform?

If this txtdayssinceraise is in your main form I think it would be

Me!Subform1.Form!ControlName

So something like

txtdayssinceraise = DateDiff("d",Me![TPayRate].[Form]![PayEffDate],Date())

 

[burrina]

I don't need help referencing the subform. The subform is a continuous subform and can have many records. I would need to get the Last date when the employee got a raise.

Not just any date.

Thanks,

 

[Harybald]

TPayRate is a Subform where their Last Raise Amount is stored.
PayEffDate is a Date Field for the last time a raise was given.On the subform



NAT

 

[burrina]

I resolved the issue but Thanks.