Control can't be edited, it is bound to an Autonumber field.

[AccessBeetle]

I am having this problem editing a combobox. Which has different Rowsource based on the person logged in. When I click on it, it says above message below the form.

Name:cmbDistrict
BoundColumn:1
RowsourceType:Table/Query
Rowsource: Depends on the person logged in If spvr logs in it is qryHQ, if mngr of region1 logs in it is qryRegion1, likewise

Please let me know where should i see to fix it?

[missinglinq]

Is the field in Column(1) an AutoNumber field?

Is the combobox bound to an AutoNumber field in the underlying table?

Linq ;0)>

[NeoPa]

You won't see a fix to it. That's the correct behaviour for a control bound to an AutoNumber field. Changing that would make no sense.

[AccessBeetle]

No it is not bound to an Autonumber field. The wonder thing is I have similar stratgies in other forms, half of them works and half of them do not. I also tried to copy paste the working forms, but no luck.

[missinglinq]

What exactly are you trying to do with this combobox?

Can you Zip the file and post it here?

Linq ;0)>

[AccessBeetle]

Got an answer!! I cannot believe that I am so blind!!
The query which was bound to the form, has one of the field called DistrictID and the combobox should look up the value from the ValDistrict table. I, by mistake, selected DistrictID column from look up table ValDistrcit instead of taking it from the actual table.
Missinglinq, you were kind of right that it had an autonumber field.
Thanks guys and Merry Chirstmas & Happy New Year!!

[NeoPa]

Normally it wouldn't be a surprise that the error message was actually right, but I've had a fair few which were simply misleading to say the least, so I can only say it's generally a good idea to look there first.

Anyway, I'm pleased you managed to find your issue and Happy Christmas :)