how will i know when a user modifies a record?

[nev]

i have a bunch of databound controls on my form. and i have a modifiedbytextbox also. if a user changes anything in the record,

modifiedbytextbox.text = s_username.

which control & event can i place that code?

i tried placing it in...
bindingsource_currentchanged --> nope
bindingsource_currentitemchanged --> nope
bindingsource_listchanged --> nope

[debasisdas]

How the user modifies a record ?

[nev]

How the user modifies a record ?

thank you for replying. i know i can use the textchanged on every boundtextboxes i have on my form. but i was wondering if there is something like...

if bindingsource.isedited then
'log modified by
end if

[debasisdas]

It will be better to use an Edit option.

When the user clicks on edit only then they can make changes to the content and here you can set which user modified it.

[nev]

thank you, i will consider that option.

[Shashi Sadasivan]

I think the datatable object has the method HasChanges()
which returns a bool value.

[nev]

I think the datatable object has the method HasChanges()
which returns a bool value.

thank you i will look into jthat.

[nev]

dataset has the haschanges() method and i tried it but did not work correctly. i cannot use the textchanged() event of each necessary control also because they are bound controls and when a user scrolls to each record, that event will be fired which will treat the record as modified even if the user only scrolled to that record. i'm still thinking to use an edit button as my last option because i don't want users to be required to click a button in order to modify a record.

what should i do and which event to use?

[Shashi Sadasivan]

Does not work correctly?

Could you please give an example when it does not work, maybe then you could submit a bug to microsoft then

[nev]

Does not work correctly?

Could you please give an example when it does not work, maybe then you could submit a bug to microsoft then

for hascchanges to work, do i have to iterate through all the rows and check if each row haschanges? so, if i have 3,000 rows do i have to check each row 1 by 1? or can i just get all the rows that has changed then iterate through them to put the modifiedby name?

[nev]

and to add, was i correct? the dataset is the only thing that has the haschanges method? i need to know please. thank you.

[nev]

here is the code i used that doesn'st work. i placed this in my save button:

if dataset.haschanges() then
msgbox("boom!")
end if

i run the program and edited a field then clicked the save button. i expected the msgbox to pop but it didn't. so i concluded that it doesn't work.

[nev]

is anyone here willing to help a poor soul?

[nev]

ooohhh... i need to bindingsource.endedit() before checking dataset.haschanges()