V
vinod
I have a table as under:
membno name Osbal amt_recd
I created a form on this table as source and then in design view added three
more calculated controls:
Newosbal interest osbal2
I have written vba functions for these additional three controls in
modules.
these functions are placed in control source of respective controls and when
I run the form in form view these controls are populated with correct data.
What I want to do is that data in these 3 additional controls may be placed
back in the source table or in some other table because when i save the form
it can be saved only as report or form not as a table.What is the solution
to place the calculated data back in the table?
I am a novice and just trying but without any success.
will you please help!there are about 1500 recrds to deal with.
Is there a way to put the data from the calculated control (osbal2_04)on the
form to the soource table field(osbal)
thanks
vk wadhawan
membno name Osbal amt_recd
I created a form on this table as source and then in design view added three
more calculated controls:
Newosbal interest osbal2
I have written vba functions for these additional three controls in
modules.
these functions are placed in control source of respective controls and when
I run the form in form view these controls are populated with correct data.
What I want to do is that data in these 3 additional controls may be placed
back in the source table or in some other table because when i save the form
it can be saved only as report or form not as a table.What is the solution
to place the calculated data back in the table?
I am a novice and just trying but without any success.
will you please help!there are about 1500 recrds to deal with.
Is there a way to put the data from the calculated control (osbal2_04)on the
form to the soource table field(osbal)
thanks
vk wadhawan