relating to other fields..
- Thread starter Tech
- Start date
R
Rich
Guest
How many records are in the subform for the first record of the main form?
well that depends on how many products the customer wants 
take a look at the DB:
ftp://temp:temp@techftpserver.co.uk/mdffc.zip
and it's the order form....
take a look at the DB:
ftp://temp:temp@techftpserver.co.uk/mdffc.zip
and it's the order form....
R
Rich
Guest
It's taking too long to download, you need to compact and Zip it, but I suspect you have a later version than me anyway. Try posting a 97ver
excuse me pat for sticking my beak in
the field text21 that tech refers to is in the subform footer
it gets its value from the query that the sub form is based on and
as such always reflects the order total based on
what was ordered and is always accurate
i know this because it comes from a sample db that was posted
to tech by me for him to experiment with.
the field text21 that tech refers to is in the subform footer
it gets its value from the query that the sub form is based on and
as such always reflects the order total based on
what was ordered and is always accurate
i know this because it comes from a sample db that was posted
to tech by me for him to experiment with.
R
Rich
Guest
Have to disagree with you here bj, the query is not returning the correct value untill the record is saved and the form re-queried, command 161 has to be pressed twice after a new record has been created in the subform unless the user tabs to a new blank record in the subform.
well, the reason I HAVE to use the .setfocus is because VBA then says that the control needs to be focused first otherwise it will produce an error, ALL THE TIME.
I tried taking away the .text and using the .value but that didn't make any difference for some reason, just diplayed £0.00
I did do the [t1]-[t2] in the order total but of course, that doesn't write it to the order form table.
unless I use VBA for the order total text box, but then, what I use the lost focus propery or what so it updates when the amount payable value has been updated in the subform?
I tried taking away the .text and using the .value but that didn't make any difference for some reason, just diplayed £0.00
I did do the [t1]-[t2] in the order total but of course, that doesn't write it to the order form table.
unless I use VBA for the order total text box, but then, what I use the lost focus propery or what so it updates when the amount payable value has been updated in the subform?
it still don't work! 
Private Sub Order_Total_Click()
it still shows £0.00! even if I use the .text property
Private Sub Order_Total_Click()
Code:
Dim x As Currency
Dim y As Currency
Me![PurchasesSubForm]![T1].SetFocus
x = Me![PurchasesSubForm]![T1].Value
Me![PurchasesSubForm]![T2].SetFocus
y = Me![PurchasesSubForm]![T2].Value
Dim calc As Currency
calc = x - y
cmdrefresh_Click
End Subit still shows £0.00! even if I use the .text property
R
Rich
Guest
You need to study the replies
Me.txtTot = Me![PurchasesSubForm]![Text21]
where txtTot is total order renamed, the rest of your code is not required, but you need to save/update the changes to the subform first
Me.txtTot = Me![PurchasesSubForm]![Text21]
where txtTot is total order renamed, the rest of your code is not required, but you need to save/update the changes to the subform first
U R THE MAN!! Thank-you soo much o, u just made a great start to the day before uni
*kisses and hugs* lol
so, how would I tell it to update that text box in the main form automatically if the values change on the subform OR if they have moved from 1 record to another?
I tried using the form_oncurrent but that makes the value 0.00:
this is in the form_oncurrent..... but doesn't work, so i deleted it...
o, u just made a great start to the day before uni *kisses and hugs* lol
so, how would I tell it to update that text box in the main form automatically if the values change on the subform OR if they have moved from 1 record to another?
I tried using the form_oncurrent but that makes the value 0.00:
Code:
Order_Total_Clickthis is in the form_oncurrent..... but doesn't work, so i deleted it...
Last edited:
Rich you would need to go to the thread in the forms
section of this great site to get the whole background of
what we are talking about.
i dont know how to get you there but it does make interesting
reading.it was posted by me on 2/02/2003
i think i might just pull my head in at this stage
section of this great site to get the whole background of
what we are talking about.
i dont know how to get you there but it does make interesting
reading.it was posted by me on 2/02/2003
i think i might just pull my head in at this stage
