Evaluation Notice

burrina

Registered User.
Local time
Today, 18:45
Joined
May 10, 2014
Messages
972
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.
 
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())
 
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,
 
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
 

Users who are viewing this thread

Back
Top Bottom