No items to display

[GingGangGoo]

After successfully building and using my Access app, suddenly I am getting "No Items to display" when I try to add data using a related items popup form.

I have checked all the tables and queries, and nothing has changed. The data is all intact, the queries pull all data together correctly, etc.

Related tables are: Contacts, Activities and ActivityContacts. ActivityContacts has lookups to the Activity Table (ActID) and the Contact Table (FullName), and Role (I defined)

Views are: Activities and New Activities (both basically the same except New is set to open to a new record) both are based on the Activity table. Both have a related item control based on ActivityContacts, with a popup of PartSlct.

PartSlct is a form that is based on ActivityContacts and has an autocomplete control from a query ContactsExtended so that I can choose any Contact to add.


When I open the form to update an existing activity with new participants, I can see existing participants and I can see and click the add link but the form that should open, PartSlct, is now returning the "No Items..." message.

The same thing happens when I create a new activity and try to add participants.

Can someone help me figure out what went wrong so I can get this working again. This is the main use for my app, and so we are dead-in-the-water, right now.

Thanks

 

[jdraw]

How about posting a copy of the database? Just enough data to show the problem.
Remove anything private/confidential.

 

[GingGangGoo]

Well, in the process of making a "dummy" copy, I deleted and then re created a new ContactActivity Table, and suddenly the problem is solved. Not sure what the heck got corrupted, but there it is.
In case anyone else has this issue here is what I did:
1. Saved a copy of the db to my desktop, and converted the tables in that copy to local (not linked) tables, so that I could import them into my app
2. Imported the table I needed into the app
3. Renamed my orignal (problem table) ContactActivity2
4. Renamed my imported table ContactActivity (removing the 1 the import added)
5. Went through all queries and forms, etc, and reset them to the correct table.
6. Checked everything out
7. Deleted the original table.

Sheese, sure hope this doesn't happen again, but if it does at least there is a work around.