create inventory in Access

[mabino79]

here is the db

 

[mike60smart]

Hi
I modified the Subform so that it is a Continuous Form View and the used =Sum([ActualQty]) in the Form Footer

Is this what you need?

 

[mabino79]

want on product basis not on Purchase (head) basis. if it has multiple product than it should show the current stock of the each product.

 

[mike60smart]

I have no idea what it is you want to see on the Form.

Can you upload an Excel or Word document showing exactly what you want to see on the Form??

 

[mabino79]

thanks for all above i have done all till

now i need to validate the value as

if the Main Form value = Purchase than
Sub form Qty should be more than 0, otherwise it will be less than the txtTotalQuantityinStock (which is a calculated query)

have created as below, but getting error, please help to rectify.

Thanks in Advance

IIf([TransactionType]="Purchase",[Forms]![tblInventoryTransactionSubForm]![Qty]>=0,[Forms]![tblInventoryTransactionSubForm]![Qty]<=[txtTotalQuantityinStock])

please suggest where i am going wrong.

 

[CarlettoFed]

Meanwhile in the attached file there is no query or control named txtTotalQuantityinStock, you should say where you entered the IIf (...) control statement they suggested.
Also remember that it is very important to correctly set the various Properties of the fields of the tables such as:

Required (essential so that a value must always be entered in a field)​

Allow zero length​

Indexed​

that you have never managed.

 

[mabino79]

eanwhile in the attached file there is no query or control named txtTotalQuantityinStock, you should say where you entered the IIf (...) control statement they suggested.

worked

([Forms]![frmMain]![TransactiontypeID]=1 And [Qty]>0) Or [Forms]![frmMain]![TransactiontypeID]>1 And [Qty]<=[Form]![txtTotalQuantityinStock]