Hello HiTechCoach,
That group boss has been changed before I came in, and no one knows that consultant's contact info....... the current database MDE only working on Access 2003.
I think MDE file can run on Access 2007, but it has to be come from 2007 mdb. If we have the original mdb file, I can update it to 2007 mdb first, then from there, save as lock down file mde.

So, for my two problems, what should I do to let this database work?
1. few fields data can not be saved in the projects table;
2. the error message for the SubForm --ProjectDetails “The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.”

Thank you very much,
Cindy

Hi Everyone,
Just let you know that I can save my records, here is my code
**

Private Sub IndexCode_AfterUpdate()

Dim NewProjectPlanning As DAO.Database
Dim rst As DAO.Recordset
Dim strSQL As String

Set NewProjectPlanning = CurrentDb
strSQL = "select IndexTitle,[Section Director]As SectionDirector,[Program Manager] As ProgramManager ,[Program Admin Asst] as ProgramAdminAsst from [Index Codes, Titles] where IndexCode='" & Me.IndexCode & "'"
Set rst = NewProjectPlanning.OpenRecordset(strSQL)
Me.strIndexTitle.Value = rst!IndexTitle
Me.strSectionDirector.Value = rst!SectionDirector
Me.strProgramManager.Value = rst!ProgramManager
Me.strProgramAdminAsst.Value = rst!ProgramAdminAsst
End Sub
**

But this problem is still in there:

the error message for the SubForm --ProjectDetails “The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data.”

Thanks,
Cindy

Do you have memo fields and using DISTINCT? If so check out http://support.microsoft.com/kb/896950.

Thank you very much, Malcolm. I did a little change after I read that article. And.......................................It works:-)

Cindy