Editing in Form Controls

[waqas]

hi experts,



i have total 15 controls text box and combo box on my form.
i want to know in which control user edit data and i want to insert only edited controls data in other table. how can i write insert query?

[waqas]

hi experts

can any one guide?

[waqas]

hi experts,

i have total 15 controls text box and combo box on my form.
i want to know in which control user edit data and i want to insert only edited controls data in other table. how can i write insert query?

[goodguy]

You are confusing readers by using the word INSERT with edits. Insert applies to new records only. Edited records are saved via UPDATE statement. You have to check the On Dirty event of each control and add its sql code segment to your query. But mind you, the code you are going to end up writing is just not worth the effort; you are far better off writing the full update sql.