Form controls not displaying in details section

  • Thread starter Thread starter Chris Nieboer
  • Start date Start date
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
 
-----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
.
Click to expand...
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
 
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)
 
Back
Top