I am having problems with Continuous forms....I had already started this in another thread but now i restructured a bit and better to start new...
Attached i'm attaching a sample DB with what I have...
In Form1, i have a subform subInvoices....in the footer of the continuous form i have a total that sums the invoice amounts. i'd like that when the user clicks the command button, that total is transferred to the text box 'value of goods FCY'. i tried doin it as u can see in the DB but i'm getting an error...
also, i'm still not feeling comfortable with the updating of the continuous form table 'SInvoices'. i'd like the changes to the subform are updated to the table when the user clicks the command button. is this at all possible? also is it possible to update certain fields in the table that are not mentioned in the form..for example i'd like to remove the columns currency and shipment ID from the subform and these would be taken automatically from the main form controls (Shipment ID and Invoice Currency respectively).
I appreciate very much your feedback.
Thanks
Attached i'm attaching a sample DB with what I have...
In Form1, i have a subform subInvoices....in the footer of the continuous form i have a total that sums the invoice amounts. i'd like that when the user clicks the command button, that total is transferred to the text box 'value of goods FCY'. i tried doin it as u can see in the DB but i'm getting an error...
also, i'm still not feeling comfortable with the updating of the continuous form table 'SInvoices'. i'd like the changes to the subform are updated to the table when the user clicks the command button. is this at all possible? also is it possible to update certain fields in the table that are not mentioned in the form..for example i'd like to remove the columns currency and shipment ID from the subform and these would be taken automatically from the main form controls (Shipment ID and Invoice Currency respectively).
I appreciate very much your feedback.
Thanks