Combobox shows more than 100 ID but doesn't select any past 100.

[Khazii]

Hi there,



As title suggests I am having difficulties selecting any 'patient' from a combobox of over 100 unique primary key ID's.

Below are 2 images. The first one shows me selecting patient 94 who has a unique ID of 101. The second picture shows that it doesn't update the patient ID. However ANY patient with an ID of 100 or below selects normally. (First column is Patient ID. Second column is ID (Primary Key))

Any idea what causes this? Any help would be greatly appreciated.

[orange]

You have marked this as Solved???
Do you have a question?
If so, please describe the application in simple English --no jargon, no database terminology - so that we understand what you are trying to automate/support. Readers need to understand what you are trying to accomplish before offering focused advice as to how it may be accomplished with Access.