Problems with my 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!!!!

 

[jazzz]

All data is stored in a table not in a form. A form is just a way to view your data. What I suggest is build a query from your table and then base your report via the query. That way you have more ways of basing your criteria via the query using expressions.

 

[KyleS]

damanjaz is correct.

But Information is temporarily help on a form in an "instance" as long as the form is on the record you want when the report is opened, this can be done. (although I do recomend using a tble or query to base your report off of).

Option A) On the Control Source for your report, leave it blank. You'll have to build an expression for each field.

Something like this: Me.[FieldName] = Forms![FormName]![FieldName]

So if you have a field "FName" on "Form1" then your FName field on your report will read like this: Me.FName = Forms![Form1]![FName]

Option B) You could base a query off the form. Create a query that looks like the one the form is based on, but with criteria like this: =Forms![Form1]![FName] on your "FName" field. This will bring up a query that has only the record displayed on the form, and you can put that query name in the Control Source of your report (Replace FName with your unique identifier)

If you need further explanation/elaboration on either/both of these, please ask.

Kyle :