Can't see records in 'Database View' of a form.

[Guest]

I have a 'Purchase Orders by Vendor' form that includes a 'Purchase Orders'
subform. The subform is set for "datasheet view." In the form view the
'Purchase Orders' sub form displays only the column headings, not the actual
data. Ususally in this view the inciator at the bottom of the form says
"record 1 of 1." In this case it says "record (blank) of (blank)." The fields
do show in the design view. The form is based on a SQL Query. A similar form
for customer orders displays the data with no problem. I can't see what the
differences are. What do I need to do to get my Purchase Order data to be
viewable in the P.O. subform?
Peter Pohlhammer

 

[Allen Browne]

The Detail section of a form goes completely blank if:
a) There are no records to display, and also
b) No new records can be added.

For (a), if you think there should be records, make sure no Filter is
applied. Also, open the main form in design view, right-click the edge of
the subform control, and choose Properties. Check the LinkMasterFields and
LinkChildFields properties.

For (b), make sure the form's AllowAdditions property is Yes. If the form is
based on a query, see if you can add a record to the query. (If the query is
not updatable, you will not be able to edit/add in the form either.)