Problem while entering data in Text Box

[sasi02]

Hi,

I have a text box which will be automatically populated with the distinct entries from a column.
Select distinct <Column name> from <table>.
When there is some wrong entry, i need to change it and by clicking the UPDATE button, it should update that table.
But the distinct values are populating in the text fields. But it is not allowing me to edit. I have checked the lock option also. it is locked-NO.

Kindly help.

[debasisdas]

Kindly post your code for refence of our experts.

[VBWheaties]

Hi,

I have a text box which will be automatically populated with the distinct entries from a column.
Select distinct <Column name> from <table>.
When there is some wrong entry, i need to change it and by clicking the UPDATE button, it should update that table.
But the distinct values are populating in the text fields. But it is not allowing me to edit. I have checked the lock option also. it is locked-NO.

Kindly help.

Sounds like a bound control. That being the case, make sure your recordset (or the data source that control is bound to) allows you to make changes.

But, like was already said, post code so someone can give you a better answer.