so i have a main form called orders, and subform called order dtls, they are linked so that if order is deleted the sub dtls also delete, but i want to do this in the form of buttons.
save- lets u save ur progress only if all the details are entered till then can't save record,
delete- deletes...
So I ave a form were, one text box consist of a control source equation, in this equation it is a If statement that auto updates as another 2 fields in the form change. Now I want this data calulated from the If statement also to be stored in another textbox where the control source is a field...
I have a continous form in that i have a few records, i have added a new textbox to each record, where there is an if statment that gives "1" if yes or "0" is no, now i want to be able to calculate all the number text boxes with 1 in the form footer, but i keep getting an #error.
My guess is...
i have a continuous subform called order details linked to a single form called order, in that, now i have the order status like processing, shipped, completed and returned in the main form order, in that I am able to put multiple processing orders, but after customer pays i can set to shipped...