I am having a problem with me report!!

[legs00]

I am working this form that retrieves certain fields from a table using two criterias. Now once the information is displayed I can choose to view this information in a report. What I want to do is transfer all that is in my form and put it in the report. But when I tried to change the properties in the form I can only use fields that are in a table and not in a form.
Can anyone help me!! Is there a way to get the information from a form and not a table!!!!

 

[dawnd3]

all data is originally bound to the tables. The form only displays the data from a table. You can run the report and use the data that is displayed in the form as the criteria for the report. Is the form showing one record at a time? If so, create a button that runs the report and in the DoCmd.Openreport code have it look to the form for the record number or id. Dawn

http://www.calliopeconsulting.net