Search results

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

nope no partial shpping

its a subform and a form

Option Compare Database Private Sub Customer_ID_AfterUpdate() Me.Customer_Name.Value = Me.Customer_ID.Column(1) End Sub Private Sub Customer_Name_AfterUpdate() Me.Customer_ID.Value = Me.Customer_Name.Column(1) End Sub Private Sub Detail_Click() Me.GrandTotal.Value = Me.FinalTotal.Value...

Private Sub Quantity_AfterUpdate() Me.Recalc End Sub Private Sub Quantity_Click() Me.Recalc End Sub Private Sub Size_AfterUpdate() Forms![Order_frm]![OrderDtl_frm].Form.ID.Value = Forms![Order_frm]![OrderDtl_frm].Form.Product_ID.Value + "-" +...

yes, it does but it gives a vba error runtime error 3, as of my guess there is a query inside and other query as my stock dtl is a query and orderdtl is also query

i just tried that too, and it should work, but now, i get an vba error "runtime error '3'", for wht i did in the query i created was, the form record source for the sumform "orderdtl" was already a query, so i amended that itself and added the new fields, but one of the fields involve in...

i tried that, but you need to hav the data stored in a table for it to happen

where should this be pasted, im quite new to vba, here is my code so far:

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