[MS_AccessPros] Rows does not delete in a table

 

Hi All,

I have a Form "All Reports" having a unbound List Box "List5" its Row Source is:

SELECT [tblReportsList].[ReportName] FROM tblReportsList ORDER BY [ReportName];

Every thing is OK, except a new problem i am facing is that if i delete a row from "tblReportsList" and open Form "All Reports" that deleted row is not there in the List5, but after closing Form "All Reports" and opening again the deleted row of "tblReportsList" is showing there.

Form "All Reports" on open event is:

Private Sub Form_Open(Cancel As Integer)

    DoCmd.Close acForm, "MainMenu"

    'This provides an informative and professional

    ' appearance to our Form Title Bar

    Me.Caption = "  SAC-Pakistan - Report Date Manager." & _

    " Today is " & Format(Date, "dddd"", ""d/m/yyyy")

  

    ' We call these two Procedures to get the

    ' current Report Names in our table

    ReportNamesDelete       <========

    ReportNamesToTable     <========

End Sub

I do have above two Subs.

ReportNamesDelete is also not working in this database, in my other database if a row is deleted in table and form All Reports is opened it shows like #Deleted .................... and next time when form is opened that report name is not there.

Any help and suggestion, why this is happening in this database. I even deleted all from tblReportsList" and it automatically is filled with all deleted entries next time i open it.

Regards,

Khalid

__._,_.___

---

Posted by: khalidtanweerburrah@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___