Form is blank

[zufie]

I don't get it!

I created a form from a query.

However, when I look at Form View the form is blank.

That is, none of the fields show.

I ensured that the YES is selected under Visible on the Form
properties.

It must be that the query returns no values?

That is, if the query contains no records then my form cannot display
fields/controls nor records?

Thanks in advance,

John

 

[KARL DEWEY]

It must be that the query returns no values?
Do you run the query to see if any records are dispalyed?

 

[KARL DEWEY]

Add a dummy record so your query will pull it.

 

[John W. Vinson]

I don't get it!

I created a form from a query.

However, when I look at Form View the form is blank.

That is, none of the fields show.

I ensured that the YES is selected under Visible on the Form
properties.

It must be that the query returns no values?

That is, if the query contains no records then my form cannot display
fields/controls nor records?

It will be blank if both of two conditions apply: 1) the query returns no
records so you can't see any existing data and 2) the query is not updateable
so you can't see the empty "new record" either.

Try opening the query in datasheet view. Does it have any data, or does it
have the blank *> new record? I'm betting it has neither.

If you want the form to display and edit data, you'll need an updateable query
that returns data; perhaps you could post the SQL of the query and indicate
something about the tables involved if you'ld like help doing so.

 

[zufie]

It will beblankif both of two conditions apply: 1) the query returns no
records so you can't see any existing data and 2) the query is not updateable
so you can't see the empty "new record" either.

Try opening the query in datasheet view. Does it have any data, or does it
have theblank*> new record? I'm betting it has neither.

If you want theformto display and edit data, you'll need an updateable query
that returns data; perhaps you could post the SQL of the query and indicate
something about the tables involved if you'ld like help doing so.

John, Here is the SQL:

SELECT [qry Days Orders].Expr2, [qry Days Orders].[Receive Materials
Yes], [qry Days Orders].[Receive Materials No], [qry Days Orders].
[Days Passed 1 Week], [qry Days Orders].[Days Passed 2 Weeks], [qry
Days Orders].[Days Passed 3 or more Weeks], [qry Days Orders].
[Satisfied Yes], [qry Days Orders].[Satisfied No], [qry Days Orders].
[Further Assistance Yes], [qry Days Orders].[Further Assistance No],
[qry Days Orders].[Quality Assurance Call Made YES]
FROM [qry Days Orders]
GROUP BY [qry Days Orders].Expr2, [qry Days Orders].[Receive Materials
Yes], [qry Days Orders].[Receive Materials No], [qry Days Orders].
[Days Passed 1 Week], [qry Days Orders].[Days Passed 2 Weeks], [qry
Days Orders].[Days Passed 3 or more Weeks], [qry Days Orders].
[Satisfied Yes], [qry Days Orders].[Satisfied No], [qry Days Orders].
[Further Assistance Yes], [qry Days Orders].[Further Assistance No],
[qry Days Orders].[Quality Assurance Call Made YES];


This is based on another query, qry Days Orders.

qry Days Orders is composed of the table Caller, the qry DaysReport1
and qryQAMaterialCallersCheckboxResponsesSums.

Hope this helps,

Thanks,

John

 

[John W. Vinson]

SELECT [qry Days Orders].Expr2, [qry Days Orders].[Receive Materials
Yes], [qry Days Orders].[Receive Materials No], [qry Days Orders].
[Days Passed 1 Week], [qry Days Orders].[Days Passed 2 Weeks], [qry
Days Orders].[Days Passed 3 or more Weeks], [qry Days Orders].
[Satisfied Yes], [qry Days Orders].[Satisfied No], [qry Days Orders].
[Further Assistance Yes], [qry Days Orders].[Further Assistance No],
[qry Days Orders].[Quality Assurance Call Made YES]
FROM [qry Days Orders]
GROUP BY [qry Days Orders].Expr2, [qry Days Orders].[Receive Materials
Yes], [qry Days Orders].[Receive Materials No], [qry Days Orders].
[Days Passed 1 Week], [qry Days Orders].[Days Passed 2 Weeks], [qry
Days Orders].[Days Passed 3 or more Weeks], [qry Days Orders].
[Satisfied Yes], [qry Days Orders].[Satisfied No], [qry Days Orders].
[Further Assistance Yes], [qry Days Orders].[Further Assistance No],
[qry Days Orders].[Quality Assurance Call Made YES];


This is based on another query, qry Days Orders.

qry Days Orders is composed of the table Caller, the qry DaysReport1
and qryQAMaterialCallersCheckboxResponsesSums.

This query will indeed not be updateable, since it has a GROUP BY clause.
Since you're not visibly using any Sum or Count or other totals operations,
try changing it to a simple SELECT query by unclicking the Greek Sigma icon.

I don't know anything about qry Days Orders of course; does IT return any
records, and is it updateable? Why are you basing another query on this query
rather than just using [qry Days Orders] as the recordsource for your form? If
it's based on three more layers of queries, it probably isn't going to be
updateable.

I wonder if you're going about this in the right way to begin with; typically
a Form should be based on a simple one-table query and have one or more
Subforms to display related data, rather than trying to create a Great Master
Query that contains everything. As in your case, such a query may contain
nothing at all (because you have the default inner joins to other tables), and
will probably not be updateable.