1.Actually, I wanted the report to be shown in the sequence in which the entries are made in the shed and meter sub forms, but if it is working on alpha sort rule then it is fine. there is no problem. Thank you.
2. I want to select the offer number to print the offers.
3. As per your suggestion I have removed the criteria from the print query.
4. As per your suggested filter criteria, I have currently blocked this code from the print button in the offer entry form.
And instead of this, the PrintSelect form has been set to open which will ask the user for the range of offer numbers to print the offer.
'DataToFourColumns
'DoCmd.OpenReport "GREY_OFFER", acViewPreview
I worked very hard the whole day today on the code given by you and the link given by you but still I am not able to code this print range form (PrintSelect) please help me in this.
5. Please also explain that instead of all the data of greyshed file being copied in the greytemp file, only the data related to the range of offer numbers which will be entered in the print select form should be copied in the greytemp file. How would this be possible?
6. The expression you suggested for total meter was not working even after several attempts, after that I added the offer ID field in the print query and added that field to the report, which made the expression work now. now I will set the offer ID text box invisible. thank you very much.
Please check the attachment