CODEWITHSUNDEEP
ms-access-2007
Chelle McGaughey
Chelle McGaughey

Reputation: 3

MS Access form not displaying data from the tables

I'm building a new Access 2007 database with a large number of tables. Designed a form with multiple tabs to display the fields from various tables, which all have a relationship with each other. When new data is entered it is all being saved correctly to the various tables. However, when the form is opened it is not displaying any of the data stored in the tables. The form properties seem to be set correctly, it allows additions and editing and is not set for data entry only. Running the query that is the recordsource fails to return any records, which looks like the problem lies there, and yet the recordsource must be correct if it is able to save the new data entered to the right tables. Any ideas on what the problem might be?

Upvotes: 0

Views: 7581

Answers (1)

Mulesoft Developer
Mulesoft Developer

Reputation: 2824

Check you database connection If database connection is established correctly then you need to check you database query e.g if you are writing this query

Select * from tableName

Just copy it and run in access sql query editor if that work fine it means some thing is wrong in you form data retrrvil mechanism. Hope it helps you

Upvotes: 1

Related Questions