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!