Issue Ticket

[jervin via AccessMonster.com]

Hi,

I had 2 tables

tblinventory
tblIssuelines
fields are
StockID,Desc,Qtyonhand StockID,Desc,
QtyIssue

Query
QryIssueLines --- Link by StockID of the above two tables..

Now , I had a form an Issue ticket form with the data source from
QryIssueLines. I had a save button on my form it works fine. Now i wanted to
have code on my save button that will subtract whatever the QtyIssue from my
Qtyonhand base on the StockID enter. currently this is my click event of my
save button.

Private Sub btSave_Click()

Me![req_id].SetFocus


Me.btFirst.Enabled = True
Me.btPrev.Enabled = True

Me.btNext.Enabled = True
Me.btLast.Enabled = True

Me.btSave.Enabled = False
Me.btCancel.Enabled = False

Me.btAdd.Enabled = True
Me.btEdit.Enabled = True
Me.btDelete.Enabled = True

Me.btPrint.Enabled = True

Me.DateOrd.Locked = True
Me.Proc.Locked = True
Me.sro.Locked = True
'Me.UseMat.Locked = True
Me.ReqLines.Locked = True

DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70



End Sub

Any help is greatly appreciated...

 

[Rob Oldfield]

Sorry for the sarcasm, but you think it would help if you said what the
problem was?