Search results

I there a way to determine whether or not my checkbox within a form is ticked or not dependant on another value within a field? I have a field called 'DaysRemaining' and another check box field called 'Expired'. I want the expired checkbox to be ticked if the value within 'DaysRemaining' is...

Hi is there anywhere to do this within the form and not using a query?

Hi sorry not the best on access. I want it so that it is on the form and not using a query. The code I have the moment in my 'DaysRemaining' field is: =DateDiff("d",Date(),[RenewalDate]) The control source of the field 'RenewalDate' is 'RenewalDate' and the name of this field is the same.

Thanks for the reply, I have looked at those earlier on. When I specify two dates in my formula such as... DateDiff("d",date(),#21/05/2013#) It works fine. However I need it to recognise my field and every time I switch the date to [Field], it just comes up with #name? error and I can't get...

Hi I'm new to these forums and not the greatest on Access so any help is muchly appreciated. Basically I have a form with the fields 'RenewalDate' and 'DaysRemaining'. At the moment I have this in the control source of my 'DaysRemaining' field... DateDiff("d",Now(),[RenewalDate]) However...