A
Andrew Tatum
Hey guys -
I have this code so far. I need CompanyID to "reset" whenever I click
for the next record. Right now, it stays stagnet while other fields
change. Any idea what's going on?
Private Sub CompanyID_AfterUpdate()
Me.InvoiceID = Null
Me.InvoiceID.Requery
Me.InvoiceID = Me.InvoiceID.ItemData(0)
End Sub
Private Sub Form_Current()
Me.InvoiceID.Requery
End Sub
Private Sub Form_Load()
Me.CompanyID = Me.CompanyID.ItemData(0)
Call CompanyID_AfterUpdate
End Sub
I have this code so far. I need CompanyID to "reset" whenever I click
for the next record. Right now, it stays stagnet while other fields
change. Any idea what's going on?
Private Sub CompanyID_AfterUpdate()
Me.InvoiceID = Null
Me.InvoiceID.Requery
Me.InvoiceID = Me.InvoiceID.ItemData(0)
End Sub
Private Sub Form_Current()
Me.InvoiceID.Requery
End Sub
Private Sub Form_Load()
Me.CompanyID = Me.CompanyID.ItemData(0)
Call CompanyID_AfterUpdate
End Sub