Recent content by TMK

yes tht has been done, where u get to delete the order only if order is completed or returned, but before those steps there is pending, processing and shipping, so i will speak with the staff and see their opinions too!

will look into tht too! thanx again!

yes ill get back soon as i think of a way to use the flag option and get back on wht i cooked up! Thanx guys!

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...

i was able to bypass the error with a timer event, it works as desired!

So I tried do what you said, but i encountered a new problem,the if statment uses the condition "StockOnHand<Quantity", here the Quantity is a stored value, but the "StockOnHand" is a dlookup value which is also not saved, what do ido then? For this form i use a query(orderdtl) as a record...

i wanna use tht value in another calculation

ohh ryhttt, i got u, lemme try tht

yes, it doesn't fire, but if i remove the if statement and make the text box unbound, and i enter data manually, the after update event works, but not with an automatic calculation like if statement

So what must happen here is the Iff Statement textbox(BalanceStock) will display "possible" or "not", is quantity smaller than stock available on and WHAT I NEED IS after tht answer comes its status "possible" or "not" must be pasted in textbox(Stock), automatically after BlanceStock value changes.

I will try and lyk Thanx!

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 solved it! Since is get the error when i add the query to the query been used by the form, I added an empty field to the table instead, and in the form i did a dlookup to get if the stock is available form the query and get the value for each record automatically and recalc data when i login...

I solved it! Since is get the error when i add the query to the query been used by the form, I added an empty field to the table instead, and in the form i did a dlookup to get if the stock is available form the query and get the value for each record automatically and recalc data when i login...

no help with the query too