Disabling Field in a form

[spn200286]

Thank you very much for your time and patience, that's working now

and thank you for your tips
(i have risen rep where i can)

1 more question, why did you use "2" instead of the name, is it because that's the id for private individual?

 

[CBrighton]

Thank you very much for your time and patience, that's working now

and thank you for your tips
(i have risen rep where i can)

1 more question, why did you use "2" instead of the name, is it because that's the id for private individual?

The combobox has the first column bound so the .Value is the first column. In your recordsource the first column is the ID rather than the name.

 

[spn200286]

i remember that now thank you once again
(i remember why i never liked programming at uni, so easy to make a mistake)

 

[JamesMcS]

If you look at the "bound column" property of clienttype, that will show you what column in the table it's looking at when you're using the value in code.