Need Help in printing report with current data

[braimi]

HelloI have a serious issue, please if some one can help me.I have three forms "Owner" main form, "Tenant" Subform and "Trans" Subform in "Tenant" Subform.I also have a report created but I am facing problem in printing single record from current view.Please tell me that how I can do this???Please it is urgent.Thanks

 

[PNGBill]

If you have a report for all the tenants and it's data source is a query that selects all the tenants and this works then you are just about finished.

If this doesn't work, get your query to produce the data and when that is working get your report to display, total etc, the data the query produces.

Then, on the form where you have just one tenant showing, ie one record displayed, you use your tool box, add a command button to preview the report and you should be given the option to match fields - restrict the data.
Follow the wizard and you should then have your report that worked for all records now just show you one record.

 

[braimi]

Thanks PNGBill for your reply, but I am still not able to get it work.

Let me clear you about the scenario I have. The three froms I have created from three tables.

Then I link the third table on 2nd table as a subfrom and once it was done I link 2nd table on the main table as subform.

I have no problem with the functionality of the forms as they are working normal and without any error the only problem I am getting is that I can not print only the current record from the form.

I am attaching an empty file containing forms and report for your review so that you can understand it well and be able to help me out more quickly

 

[PNGBill]

Check your download. Did you remove any tables, forms, reports and queries that are not needed for this issue and leave some bogus data.
Then compact and repair and attach the file. Should be way smaller then 1mb.

 

[braimi]

I only removed Switchboard thing and rest all the tables and forms are needed which are currently there in the file. I have repaired the file and it is already less than 1mb. I am attaching the file again.

Thanks

 

[PNGBill]

Downloaded but could not open. Is this an access database file or a backup of same?

Also, I am using access 2000 - bit old but still works. Can you save in this format?

 

[braimi]

I have converted the file to Access 2000 format and reattaching.

Please check and let me know if it works.

 

[PNGBill]

It opens. Give a few minutes to look at it.

 

[braimi]

Ok sure... I am waiting for your reply. just for your information that SenderDetails form is the main form.

 

[PNGBill]

Your form BeneficiaryDetails - Delete the Command28 button you have and add a new button to open the report but this time put the button on the main form. Not the subform.

 

[braimi]

Ok I have deleted the Command 28 button from the Remittance Details. It was not on BeneficiaryDetails.

And what show I do next after creating a new button on the main form?

 

[PNGBill]

The report needs to be opened where you have the BeneficiaryID available. You do not have this on your subform or on your remittance details form.
If you can build the beneficiary into this form it may work.

 

[PNGBill]

see attached file - your report works.

 

[braimi]

I tried with that before but it didn't work :-(, because a beneficiary can have more than one records in its remittance details. I am sure that there can be some VBA code to achieve this. But I am not getting it. :-(.

 

[PNGBill]

I got the report to work. What part of the report is not correct ?

 

[PNGBill]

I realise - i think. The report is 14 pages and should only be 1 or 2 pages. You need to a query that looks up data on the RimittanceID primary key where as your report is using RemittanceBenID as the table link and therefore selects all remittances for that beneficiary rather then a report on just that Remittance.
I will do a query for you.

 

[braimi]

Report is working but it is not working with the current remittance details. Try to make a new remittance record and then try to get the print report and see if it shows you only the current record which you just entered. It should not show all the records starting from the 1st remittance till the last.

 

[PNGBill]

I have changed your report query so it includes the RimittanceID which it must do if you want to match the report to the form.

next job is to get it to link to it only reports on the one remittanceID - will get this working and send to you soon.

 

[braimi]

Ok I am really thankful for your help and waiting to hear from you.

Thanks

 

[PNGBill]

RemittanceDetails Form works