Connecting Tech Pros Worldwide Forums | Help | Site Map

how to get the value from different form and calculate

Familiar Sight
 
Join Date: Oct 2006
Posts: 140
#1: Nov 14 '06
hi

I ve a form with some txt field and total_hour field.
this total_hour i want to use in another form.

how to call in day1_hour (txtfield). in controlsource i was calling the same value from that table.

its not working. help me

msquared's Avatar
Administrator
 
Join Date: Aug 2006
Location: Dublin, Ireland
Posts: 10,886
#2: Nov 14 '06

re: how to get the value from different form and calculate


Quote:

Originally Posted by indhu

hi

I ve a form with some txt field and total_hour field.
this total_hour i want to use in another form.

how to call in day1_hour (txtfield). in controlsource i was calling the same value from that table.

its not working. help me

It all depends on how you are trying to use it.

If you want the default value on the second form to be equal to current records value on the first form. Something like this should work if both forms are open.

In the properties of the textbox on the second form go to default value and set it to =[Forms]![Form1_Name]![total_hour]. If you want to store it in a field on the second form make sure you set the control source to the appropriate field.

Mary
Reply


Similar Microsoft Access / VBA bytes