Hi, I have a database on scale Modelling stocks, the form F Modelling Stocks displays (with images) records with scale, source, title, price, description, location and so on, it also has a subform FrmForAircraftType and having for example entered a new record for Merlin lll engine 1/48 scale and all the other details for the main form fields, I would then in its subform select in the combolist Spitfire then create a second subform record selecting from the Combolist Hurricane then a third selecting Defiant and a fourth selecting Battle and a fifth selecting Wellington.
The two tables T Modelling Stocks and TblForAircraftType are related on ID ModellingStocks. One cannot filter by form on the subform, choosing Spitfire for example, it asks for ID ModellingStocks ! .
I now have a query Qry T Modelling Stocks for Filtering that brings together T ModellingStocks and TblForAircraftType on ID ModellingStocks and a copy of the main form called F Modelling Stocks For Query Aircraft Type that now draws its content on that query .
Method is clunky though...
1) launch query in design view then type for Criteria in the AircraftType field Like "*Spitfire*" and save and close query.
2) launch F Modelling Stocks For Query Aircraft Type and it displays records for subform entry Spitfire.
3) close F Modelling Stocks For Query Aircraft Type and launch F Modelling Stocks For Query Aircraft Type and alter entry to Like "*Lancaster*" and save and close
4) launch F Modelling Stocks For Query Aircraft Type and it displays records for subform entry Lancaster. otherwise it doesnt refresh !
I wish to have a combolist on the main form displaying the AircraftType field entries so choosing from that list would enter that choice in the criteria box in the query on which the form is based and have the form display the items for that aircraft.
Better still to have that on the original main form F Modelling Stocks that is showing all records, and have it launch the form F Modelling Stocks For Query Aircraft Type that is based on Qry T Modelling Stocks for Filtering , saves me closing one form and opening the other ! Can one do this ?
I am very rusty on the setup having last dabbled many years ago, so a talk through 'dummies guide' step by step of what to do would be most welcome and essential.
I also need to have access to this Access database when at shows, how is this best done ? I dont want to carry about a laptop !
Thanking you in advance.
DBenz
p.s typed this out in the box then when submit it lost all the gaps and created one massive text block, why ? had to insert type tool and hit enter to unravel it again.