Hi
I am using Access 2010 and trying to get the results from a query to display each record in a seperate text box in a form.
My query runs from ComboBox1 After_Update in the form with no problem and leaves the results of the components of a diesel car, petrol car or van.
What I would like to happen is After_Update of ComoBox1 is the resulting records to be displayed in the form like a list with a checkbox next to the list so I can tick which componets are present.
i.e.
checkbox petrol
checkbox diesel
chexkbox oil
checkbox aircon gas
If I have a perol car with aircon I want to tick petrol, oil, aircon.
If it is a diesel car without air con I will tick diesel and oil only.
The result I need from this is when petrol is ticked the petrol ID is placed in the receiving table and so on for any ticked item when the record is saved or I move to a new record.
I am using Access 2010 and trying to get the results from a query to display each record in a seperate text box in a form.
My query runs from ComboBox1 After_Update in the form with no problem and leaves the results of the components of a diesel car, petrol car or van.
What I would like to happen is After_Update of ComoBox1 is the resulting records to be displayed in the form like a list with a checkbox next to the list so I can tick which componets are present.
i.e.
checkbox petrol
checkbox diesel
chexkbox oil
checkbox aircon gas
If I have a perol car with aircon I want to tick petrol, oil, aircon.
If it is a diesel car without air con I will tick diesel and oil only.
The result I need from this is when petrol is ticked the petrol ID is placed in the receiving table and so on for any ticked item when the record is saved or I move to a new record.
Comment