On my MS Access unbound form I display info about Product.
Values for form fields are coming from saved values in table tblProduct. One of the field in table Product is field named “ Colour”.
Scenario is next:
Where form is open I have search box for product search I find product and display info about Product on the form fields.
Now I want to edit value for Colour.
I have Colour values in tblColours and for now I have five values = White, Green, Black, Red, Yellow.
For editing value in txtColour I want combo box option.
I want combo box cboColours to select value and then selected value to put in text box txtColour.
However I do not want to see both text and Combo box on form. It should look like just as one drop down box old the time.
Need something as hiding one behind another and showing selection or changed value .