Help Needed with linking to a table

[Crabbymcdo]

Hi Guys need a bit of help

I have an access database that has been working perfectly, however it suddently stopped working as it should on Friday last week.

let me explain what it should do,

on my database I have CLOSE CALL option
when you go into there I have a section with Close Date, this should be linked to the close date column in my table
however all of a sudden the database does not recognise this column in the table, looked and looked but cannot figure out why it does not pick this up.

Ive attached the database for reference, the database is locked down so you need to hold Alt when opening to access the navigation pane

any help will be greatly appreciated

 

[dpelizzari]

Crabby, I am looking at your database, when I click on Close, I got an error on the Time() function. I believe you need to remove the paran's after Time. Other than that, it appears you are using Office 2010 or 2013, so I am getting Reference errors for Outlook.

 

[Crabbymcdo]

Indeed this database was created in 2007/2010 being run on 2010, time function works perfectly but it is just the date function that does not

 

[Crabbymcdo]

Still really need help with this if anyone can help please guys??

 

[Crabbymcdo]

Figured a fix to this myself, it was a fault with the table link on the form itself, although I could set the textbox to be linked to the correct field in the table it did not recognise it until I also set in on the actual form itself.