Edit record in form.....

[HRakibul]

hello dear,
i got a problem in making access form......
i have two lists which has the row source from different interlinked table now in the same form i need to select "ListBox" and the data of table will be shown in "Unbound"TextBox and then i can edit it and OnEnter the value will be changed and saved.

Please do not use Form record Source.
I need to do all these through VBA Code

see below DB for refrence

is it possible....
plz help

 

[Isskint]

This is possible and you wont need command buttons or the OnEnter event.

In the After Update event of your list boxes set the text box values.
In the text boxes After Update events add some code using RunSQL to update the tables based on the new value.

I have done this on your sample, have a look

 

[HRakibul]

hi Dear,
It is Awesome solution..........Thank u Thank u Very much.