Form disconnected from associated table-inadvertantly

[Les Simpson]

Somehow my quite complex multipage form cannot show data from the underlying multiple table data. This database was working fine until I saved a form with new data.

The table data remains fine.

Do I have have to go to each form object and reconnect with its respective table or can I reset the all the form table links in one go? If so how? In both cases please.

All the best

Les

 

[Jeanette Cunningham]

Losing a record source for a form is unusual.
Rebuild each query that is the record source for each form.
Perhaps there is some corruption happening in your database.
Here are some links for avoiding and dealing with corruption:

Now here's a real bummer with this site- because I haven't reached 10 posts, I can't post the links to the website with all the helpful info about corruption.

Here are the mangled links - I hope you can make sense of them. This site won't even let me paste part of a link - feeling very frustated about this rule that prevents my volunteered time helping some one else.

The name of the website is allenbrowne followed by dot com.
Go to his access tips page and scroll down till you find the heading called corruption.

 

[Banana]

Just to help Jeannette (welcome to AWF!) out -

Recovering from corruption
Preventing corruption

 

[Les Simpson]

Many thanks for your help Jeanette and Banana. I will study the help at both links.

I have the idea now that each form control has lost its respective record source as result of my actions. All the table level data and relationsships are fine.

All the best

Les

 

[Les Simpson]

This issue can be closed I found the problem. In Form Properies I had inadvertantly, somehow, switched "Data Entry" from no to yes. Restoring "no" and saving brought data back on screen. Phew.

Many thanks Jeanette and Banana.