February 11th, 2004, 11:10 PM
|
|
Contributing User
|
|
Join Date: Feb 2004
Posts: 64
Time spent in forums: < 1 sec
Reputation Power: 5
|
|
|
transferring data from command button to textbox??
Hi all,
i've created a command button (CalcTotWeight) on the main form(Order_fulfilment) to calculate the total weight in the subform(parts_sent_info). It works fine, though I am always prompted to enter the pacref before the total weight is computed. The SQL statement is as follows:
Quote: SELECT sum([weight]*[partsentqty])
FROM parts_sent_info
WHERE [parts_sent_info].[pacref]=me!parts_sent_info_subform.form!pacref; |
The "pacref" is in the subform(invisible) and the mainform(visible) too. Any idea how I can remove the prompts?
And, now I have to display the calculated total weight in a textbox "Weight" on the main form. How can i do this?
Many thanks in advance.
Regards,
Tracy
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
