Form controls not displaying in details section

C

Chris Nieboer

When I call a form from another button control the form
displays the header and footer but the detail section
remains blank

Allow Additions = true
Query is a working query that returns results

Works for the client at their office on Access 2000
I am running Access 2003 in Access 2000 mode. I also
tried running it on Access 2002 which also did not pull
up the forms properly.

ANy Ideas on what may be causing this?

Thanks
 
C

Chris Nieboer

-----Original Message-----
When I call a form from another button control the form
displays the header and footer but the detail section
remains blank

Allow Additions = true
Query is a working query that returns results

Works for the client at their office on Access 2000
I am running Access 2003 in Access 2000 mode. I also
tried running it on Access 2002 which also did not pull
up the forms properly.

ANy Ideas on what may be causing this?

Thanks
.
I noticed that when the query is empty it does not work.
At the clients site it will still open the form to allow
input but in my version this will not happen. Once again
I am using Access 2003
 
V

Van T. Dinh

The RecordSource (a Query or SQL String) may return an
empty *non-updateable* Recordset and in this case,
regardless of the AllowAdditions Property, the Controls in
the Detail Section become invisible.

I suggest checking the RecordSource, i.e. the Query by
itself and NOT through the Form and see if the Query is
updateable and not empty.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top