I'm still struggling with setting up a few Combo Boxe(s) in a Form.
In my Wholesalers Vehicles dbs I have 3-flds which I want to be in Combo Boxes in a Form:
- Make
- Model
- Dealership
Now, I never have any luck in creating Combo Boxes from flds within the Table/query itself because e.g. if I have 10-records/vehicles with the Make, '"Ford" then listed in my 'Makes' Combo Box it'll have 10-"Ford" whereas I just want "Ford" listed once. Likewise with 'Dealerships', if I have 25-records/vehicles at "Harrys Autos" then in the 'Dealership' Combo Box it'll have 25-"Harrys Autos." What I've done to I've thought to get around this delimna (although it's probably not the best solution) is I've created a qurery where the 'Make' is only listed once. Likewise with seperate queries for 'Model' & 'Dealership'. Next when I create a Combo Box for 'Make' I used the Make qeury whereby I only get the 'Make' listed once in the Combo Box. I did the same for creating a Combo Box for, 'Make' & 'Dealership'. Most important to note, for each Combo Box I made sure I have the Control Sourse linked up to the approiate Combo Boxes. When I create the 'Make' Combo Box the Control Source is 'Make' & the same with 'Model' & 'Dealership' I'd learn & remembered that important step from someone here. This right/wrong method has worked for me in the past with other dbs, HOWEVER!!! -- when I go to the Form is not editable/the data is locked, why? Might anyone know what's wrong?
Any help I'll be greatful for.