Reports not sourcing data from Forms.-URGENT!

B

BGchiq

Can someone help me, my reports are not printing the data from the forms,
when I print preview them they are all blank, before they were all showing up
on the reports, now they arn't, please respond, this is URGENT! Thanks alot!
 
D

Duane Hookom

Reports display data/records from tables and queries. Your report has a
Record Source property that defines the tables/queries providing the
records. Do you see any records in the datasheet view of your Record Source?
 
B

BGchiq

Hi there, what icon do I click to find the Record Source Property? When I
click properties I am not getting it, anything like that.
 
D

Duane Hookom

You must view the report properties. While in the design view of your
report, double-click the little square box to the left of the horizontal
ruler and above the vertical ruler.
 
B

BDchiq

In the properties tab window there are tabs- Format, Data, Event, Other, All,
I am still not seeing anything in there to click to source the data from
tables. Under the data tab, next to the record field, I have selected the
relevant table to take the data from, and yet still when I reopen the Report,
the data is not showing up from the forms.
 
D

Duane Hookom

Again, forms don't contain data. Do you have bound text boxes or other
controls to display? When you state "not seeing anything", does this mean
the report doesn't open? Or, do you see controls but no data values?

Do you have any records in the table that you selected as the Record Source
of your report?
 
B

BDchiq

yes that is it i see controls but no values

Duane Hookom said:
Again, forms don't contain data. Do you have bound text boxes or other
controls to display? When you state "not seeing anything", does this mean
the report doesn't open? Or, do you see controls but no data values?

Do you have any records in the table that you selected as the Record Source
of your report?
Click to expand...
 
B

BDchiq

no i am not seeing values in the report for the controls, and yes I have
records in the table I selected as the record source.
 
D

Duane Hookom

Do you have anything in the Filter property of the report?
If you have 5 records in your table, do you see 5 instances of the detail
section?
Try add a text box to the Report Header or Footer section with a control
source of:
=Count(*)
What value do you see in this text box?
 
Top