I know I should Know this

[Guest]

I have just created a DB with 6 tables. I created an "All Data" Query that
has all the fields from all tables. Then I created a form for the "All Data"
Query. None of the fields are showing up when I run the query or the form. I
know this has happened to me before, but I can't remember or find how I fixed
it. Hopefully, someone has an answer. Thanks.

 

[Rick Brandt]

I have just created a DB with 6 tables. I created an "All Data" Query that
has all the fields from all tables. Then I created a form for the "All Data"
Query. None of the fields are showing up when I run the query or the form. I
know this has happened to me before, but I can't remember or find how I fixed
it. Hopefully, someone has an answer. Thanks.

A form's detail section appears blank when there are no records to display and
no ability to add new ones. Most likely you have constructed a query with zero
rows in its output and which does not allow edits (almost a certainty with 6
tables).

A "one big honkin query" approach is almost never the proper way to do form
stuff. I suggest you look at some subforms and/or linked forms instead.

 

[Vladimír Cvajniga]

Try LEFT JOIN or RIGHT JOIN in your query.
Bear in mind that if you have 1:n relation you may not be able to edit data
via form... unless you set form's RecordsetType to dynaset (inconsistent
updates).

HTH

Vlado