Report Question

[magcasen]

How do i create a report that is linked to my subform that i have just sorted in a different form?

let's say i have a form named View Records and on that form i have added a subform that is linked to my Employee Table, and then on that View records form i have added a few combo box in order to sort the data on my subform on that form, now what i want to do is that, i want to link those data that i just sorted on my subform and transfer it to a report ,, is there a video tutorial on how to do this?

can you please help me or guide me step by step on how to do this?

 

[plog]

You sort a form very similarly to how you sort a report. So if the subform sort is working, you can basically use the same code to do it to your report.

Give this link a read: https://msdn.microsoft.com/en-us/library/bb243811(v=office.12).aspx

 

[magcasen]

is there any other way i can do it easily just by pressing a buttong that will show up a report based from the sorted data from my subform?

 

[Spark021]

I would make a query. You would have to reference your control in the query (your combo box) in the criteria section on your query input the following:

[Forms]![FormName]![ControlName]

Replace FormName with the name of your form
Replace Control with the name of you control (Your combo box)

The query will sort the data based on the combo box. Then simply create a report based on that query.

I hope this helps

 

[magcasen]

I would make a query. You would have to reference your control in the query (your combo box) in the criteria section on your query input the following:

[Forms]![FormName]![ControlName]

Replace FormName with the name of your form
Replace Control with the name of you control (Your combo box)

The query will sort the data based on the combo box. Then simply create a report based on that query.

I hope this helps

thanks for the response, but the thing is , i'm making a simple program from access that would do that on my subform automatically just by pressing a single button that would print preview me a report based from the sorted data from the subform that is inside my view records main form>_<

 

[Spark021]

thanks for the response, but the thing is , i'm making a simple program from access that would do that on my subform automatically just by pressing a single button that would print preview me a report based from the sorted data from the subform that is inside my view records main form>_<

Forms only display data (they dont actually contain and data). So this means you can not base a report upon a form or sub form. Reports are generally based upon tables or querys.


I would create the query and base the subform of that query as previously suggested. Then base the report of that query also. With a paramater that organised your data to what you want to be displayed.


If you have a copy of your database I see if I can help directly?