Forum Discussion
Which data entry approach to take?
Mks_1973 is correct when he said that there is only one combobox for both category and subcategory.
changing the recordsource of the combo can affect the display of your combo (previous record).
what you can do is add a "dummy Textbox" to show the SubCategoryName.
see this demo and open SalesForm on design view.
see that there is a "dummyTextbox" in front of subcategory combobox.
also note that the recordsource of the form is a Query.
Mks_1973 is correct when he said that there is only one combobox for both category and subcategory.
changing the recordsource of the combo can affect the display of your combo (previous record).
what you can do is add a "dummy Textbox" to show the SubCategoryName.
see this demo and open SalesForm on design view.
see that there is a "dummyTextbox" in front of subcategory combobox.
also note that the recordsource of the form is a Query.
Thank you so much, this is working beautifully and your example was really helpful. I still have a few things to iron out around 1) restoring the functionality allowing the SubcategoryCB combo box to set the value of the CategoryCB combo box until a category has been selected using the CategoryCB, 2) preventing inappropriate editing of the MilesTravelled and MonthsUsed text boxes if they are re-enabled, 3) I haven't worked out how to get the dummy text box to sit on top of the SubcategoryCB combo box yet, 4) numerous other things I haven't spotted yet I'm sure! But I'm well on my way thanks to your response.
to get the dummytextbox to sit on top of the combobox, on design view you clicked on the subcategory combobox and Copy it's Top property, then clicked on the dummy textbox and paste the Top property you just copied. you do the same with it's Left property. now right-clicked on the dummytextbox and choose, Position->Bring to front.
Thank you, it's all sorted now - I'm really pleased with the end result. So far so good!
