[FONT=century gothic]
Hi,I am developing a VB application with Access Back end.The DB has 2 tables,custdata(6 fields) and machinedata(15 fields).Both tables have a "ccode" field which is the primary key and the indexed field too.
I need to get printed reports of search results.The criteria are selected in searchform.frm. The results are displayed in resultsform.frm. I have placed 2 CR controls on the form,one to get the whole report(all the fields in both the tables) and an abridged report(some of the fields only).
Now I designed 2 report formats(datareport1.rpt and datareport2.rpt) with the designer(Version 4.6.1.0) .I did some font formatting and bordering as well.
When I give the .Reportsource property of the control on the form as Report I get the format alright,but the data is all wrong ie I seem to get all the records in the tables with no formatting.
When I give the .ReportSource as the DataControl(machinedatasearch-whose datasource changes with the criteria in the search form),I get the correct data,but there is no formatting whatsoever.
I have placed 2 buttons on the form to activate the printing operation.
What could be wrong?
Please help me.