Recent content by noorudden

Thanks arnelgp, i did that yesterday. all seems to be fine now.

thanks for your help But.. After spending countless hours as i am new to ms access i have found the solution to my problem. Created a textbox linking it through Dlookup to the Table where TotalStock is. Then on the stockout form and on Qty afterupdate() event procedure i have written a...

i have already checked the provided linked database in detail. and that business concept doesn't match with mine. i am only stuck on one small thing and all other things have already been sorted. In your provided video link there is a Part No and that does not apply in groceries. my question...

thanks for quick reply. please attached image. yes you are right when i am entering a stock out which is going in the Kitchen table in Qty and when i am putting a value greater than TotalStock which is in Stores it must not allowed it unless i put above 0.

Hello, I am making a Stock in and out access program and i have come to a roadblock. Table/Form StockIn > Total Stock > 70 (Number) Table/Form StockOut > Qty > 100 (Number) << this field must verify above field if it is either 0 or - then it should give the error and tab should not move...