i have a order form with a sub form orderdtl, we got the option to change the status of the order from processing to shipping, only if the desired items in the order are all in stock or in other words if the quantity is less than or equal to the available stock, but for this to happen i hav to...
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...