how to display next medical due on a subform

[sspreyer]

hi
all
right....
I have a form call "frmemployee" that holds employee's details. I have page tabs with sub forms on and the one I'm now concentrating on now at the moment is a Sub form called "medical Sub form" this holds data regarding the last medical the employee has had on continuous form e.g. MedicalDate ,Doctor , Place

now what I'm trying to do is find last medical date for the employee selected and add +730 days to show next medical date in text box on the footer of the subform

I have a sample with bubble speech show what I'm try to do

any help much appreciated this is last part of my project I'm stuck on:banghead::banghead:

cheers

shane


View attachment medical Test For Shane1.zip

 

[GinaWhipp]

This should do it...

Look in the Controls to see how it was done.

 

[sspreyer]

thanks Gina

didnt know i could use the dmax function in a text box something new i have learnt

THANKS AGAIN GINA!!!!! YOU STAR !!!!!

Shane

 

[GinaWhipp]

You're most welcome!