Form and History field please please help.

[Andyjones]

Hi Guys I have created this form based on the call tracker template from Microsfoft access 2010, however for what ever reason i can not get the history box to update after i have entered a new comment, also when the comment has been entered i need the comment box to revert back to blank with the txt appearing in the history box



Also when the the dispatched by box has been selected and an engineer selected how to i get the dispatched time to auto populate the time at wich the call was dispatched.

any help would be apreciated and please feel free to modify the form or design.

PS noticed that with the one query when it is run it keeps asking for company, yet in that particular query company is not needed as it is linked to employees i belive i have deleted it out of the sql but it keep trying to find it please please please help.

[June7]

Comment box is bound to field. If you 'blank' it, this deletes data from the field in record. If you don't want comment saved in record, why have the field?

Been a long time since I dealt with ColumnHistory. Not sure you are using it properly. http://office.microsoft.com/en-us/ac...080750367.aspx

The calculated fields for EmployeeName and the sort criteria reference Company. The GoTo combobox on EmployeeDetails also has Company field in RowSource.