By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,486 Members | 2,124 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,486 IT Pros & Developers. It's quick & easy.

how to get the value from different form and calculate

100+
P: 140
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
Nov 14 '06 #1
Share this Question
Share on Google+
1 Reply


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Nov 14 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.