hansnyc
06-14-2007, 04:48 AM
I have 2 "Quotation" forms that look identical, 1 is for export, 1 for import
they both draw from the same table called tblquotations
now each of them has a subform on which the user select services. The forms open with a code that already displays a set of pre-selected services depending on import or export
these subforms are called subfrmimportservices and subfrmexportservices. they draw from tblimpservicesquote and tblexpservicesquote. they both are made of a cbobox to select servicenames from tblservices (refservices on tblimpservicesquote) and quote to enter the price for that service.
Then I created 2 identical queries qryexport and qryimport (except of course for the names of tables it draws) and I created 2 identical reports. In the detail part of my report I placed the subform fields: servicename and quote, therefore when I select 4 services or 10 services the report just list 4 or 10.
My issue is this: the rptExport displays the services has listed on the form, ex: pickup, delivery, airport fees.
but the services displayed on rptImport come out of order.
I tried changing things in the query. the ideal would have my services listed ascending by alpha order but that doesnt work either.
Both queries are the same I actually made export first and renamed it import after changing the tables name, same for the report.
I'm out of solution, please someone help!
they both draw from the same table called tblquotations
now each of them has a subform on which the user select services. The forms open with a code that already displays a set of pre-selected services depending on import or export
these subforms are called subfrmimportservices and subfrmexportservices. they draw from tblimpservicesquote and tblexpservicesquote. they both are made of a cbobox to select servicenames from tblservices (refservices on tblimpservicesquote) and quote to enter the price for that service.
Then I created 2 identical queries qryexport and qryimport (except of course for the names of tables it draws) and I created 2 identical reports. In the detail part of my report I placed the subform fields: servicename and quote, therefore when I select 4 services or 10 services the report just list 4 or 10.
My issue is this: the rptExport displays the services has listed on the form, ex: pickup, delivery, airport fees.
but the services displayed on rptImport come out of order.
I tried changing things in the query. the ideal would have my services listed ascending by alpha order but that doesnt work either.
Both queries are the same I actually made export first and renamed it import after changing the tables name, same for the report.
I'm out of solution, please someone help!