Service Sheets.zip
Sorry to bother you again. Ive followed your tutorials and it has got me ALONG way,
I am unable to work one last thing out with regards to the dynamic drop downs.
I have set up about 8 dropdowns that are dynamically attached to each other and filterd out all the unnecessary info.
For the final step I have included the "requery codes" as follows
Code:
Private Sub cboServType_AfterUpdate()Me.cboEngOilFilter.Requery
Me.cboFuelFilter1.Requery
Me.cboFuelFilter2.Requery
Me.cboAirFilter.Requery
Me.cboCabFilter.Requery
Me.cboTransFilter.Requery
obviously this is just a very small sample of the scripting page.
Say the following script was the last of the set of drop downs that are filtering out the table. And i would like to set the only available result to be viewed in this drop down. Is there a way i can have it instantly shown instead of having to select the drop down arrow and manually selecting.
Code:
SELECT DISTINCT [Data Spread].Make, [Data Spread].Model, [Data Spread].Year, [Data Spread].EngineType, [Data Spread].Transmission, [Data Spread].Drive, [Data Spread].ServiceType, [Data Spread].EngineOilFilter FROM [Data Spread] WHERE ((([Data Spread].Make)=Forms!DataSelectForm!cboMake) And (([Data Spread].Model)=Forms!DataSelectForm!cboModel) And (([Data Spread].Year)=Forms!DataSelectForm!cboYear) And (([Data Spread].EngineType)=Forms!DataSelectForm!cboEngType) And (([Data Spread].Transmission)=Forms!DataSelectForm!cboTransmission) And (([Data Spread].Drive)=Forms!DataSelectForm!cboDrive) And (([Data Spread].ServiceType)=Forms!DataSelectForm!cboServType)) ORDER BY [Data Spread].Make, [Data Spread].Model, [Data Spread].Year, [Data Spread].EngineType, [Data Spread].Transmission, [Data Spread].Drive, [Data Spread].ServiceType, [Data Spread].EngineOilFilter;
For this particular section, i have removed the (Value = "") of the scripting.
Can any one assist please.