I am stuck with another problem... Basically, what I have is a form which is called frmPhysical Inventory. The fields I have in this form are Opening Stock, Receipts, Usage, Computed Balance, Physical Stock and Variance...
What I need is to automatically fill Receipts and Usage fields based on the dates...
Usage field is based on a table called tblMixing_Sheet..
The Receipt field is based on three tables because my clients receive materials three different ways...
Is there a way that I can fill in the Usage and receipts daily and automatically??
I tried to do a subform and in the query for the Usage and Receipts I have a criteria under the Date field which is Date(). But the thing is when I click on the new button the subform is empty and cannot add anything to the Usage or Recipts..
Any help is apreciated.. Thanx in advance..
What I need is to automatically fill Receipts and Usage fields based on the dates...
Usage field is based on a table called tblMixing_Sheet..
The Receipt field is based on three tables because my clients receive materials three different ways...
Is there a way that I can fill in the Usage and receipts daily and automatically??
I tried to do a subform and in the query for the Usage and Receipts I have a criteria under the Date field which is Date(). But the thing is when I click on the new button the subform is empty and cannot add anything to the Usage or Recipts..
Any help is apreciated.. Thanx in advance..