Off the top of my head, I think the #name error is because Access can't find one of field names.
Try modifying the syntax 'missingling' supplied, replacing the tablenames and fieldnames as appropriate.
ElapsedDays= DateDiff("y", [tablename]![CurrentDate ], [tablename]![NextServiceDate])
tct1954
Belovedcej,
I think using a bound form and controls would be easier and less coding would be required. Setting up a form, binding to a recordsource, navigating through the recordsource one record at a time, adding, deleting, updating and saving records is all rather simple. Easier to maintain...
belovedcej,
The UK Professor's slides is what I had in mind. However I think his code is going to give you errors. At least I get them [bigsmile]. Substitute the bang -!- for the periods when referring to fieldnames. Also, I've never used the syntax 'Field("fieldname"). Check this snippet...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.