Hi,
The database I am using was created by a colleague who has left the company.
It is a huge database, used by many colleagues. A colleague tried to change the fields in a combo box, however they made an error and asked me to rectify it.
I am not an Access expert, so I used an archived version and ensured the property details on the archived and current combo box were exactly the same.
However, the combo box still does not work and I cannot seem to rectify it.
As you can see from the image below in Form View, when I select option 2, it also selects option 1. If I type '2' into the box, it says it isn't an option to choose ...
This is the information in 'Row Source' on the Property Sheet.
1;">55% - Normal";2;"45-54% - Mild";3;"35-44% - Moderate";4;"<35% - Severe";"N/A";9;"Not known"
It should look like this in Form View (taken from the archived database).
I am hoping this is an easy fix! Thank you in advance.