Search results

thanx but again, when i embedd this form into aonther and link relations e.g. Order_ID, the same thing hsppens again and fields disappear. like in example below I cahnged as you said in frm line total purchase 2. When I embed it to All Supplier Oredrs , same happens. how to correct that plz.

how to set that

hi I have a form named frm line total net. in its source query design , when i link the table suppliers, the fields in the form disappear as shown. where is the problem. plz help.

thanx CJ I got it with your help . your are great >>>>>>

T

well, in the abpve pic, I want to have that when in upper filed of customer filed , some value is selected, then the lower combo box should automatically select the same value. but how

see, i uploaded it

Thanx Bob. I have uploaded it.

HI i have a form in my db called All Customer Orders. On it , there is a combo box named Customer_ID. In this form, there is a sub form named frm line total sale3. I want that if combo box named Customer_ID , one value is selected on this main form, then the combo box named Customer_ID in the...

solved

still no help

any help

In append query , C-Add, in the last field, i.e line total: [Rate_Amount]*[Quantity_Sold] i want to get this instead line total: ([Rate_Amount]-[Customers]![Discount_C]*[Rate_Amount]/100)*[Quantity_Sold] But when i do so, the sub reports in Customer_Orders report Disappear i.e. The details...

attached

thanks for reply. kindly tell me how to work that out in sample attached db

Balance should be equal to amnt net

hi ,when append query, C-Add, is invoked, it should calculate Amount_Sale present on Form Main respective to the customer, but thats not i am getting. it gets without discount. i tried to set it but in vain. that can be checked in customer orders by customer report any help

but gives error when new form entry to be made. see in attachment.

Ok . If line total filed is calculated, then how to do same next?