D
DS
I have a subform that I enter Info on from a Listbox on a main form.
The code is this so far...
Private Sub ListMain_Click()
DoCmd.Echo False, ""
DoCmd.GoToControl "SalesDetails"
DoCmd.GoToRecord , , acNewRec
Forms!Sales.SalesDetails!LineID = _
Nz(DMax("[LineID]", "SalesDetails"), 0) + 1
Me![SalesDetails]![ItemID] = Me.ListMain.Column(0)
Forms!Sales.SalesDetails!MenuNum = Forms!Sales!Text65
Me.Refresh
DoCmd.Echo True, ""
End Sub
This works really well...
I want to add another statement to it and I am confused.
I added 3 new yes/no fields that I need.. they are
Taxed
Inclusive
No Tax
I want to loop through the records after a new item is present and if
the [Location] field (Located on the Subform "SalesDetails"} = "Bar"
Then if any Records or Items are "Taxed" then all of the "Inclusive"
fields will become false and the "Taxed" field for that record will
become true.
Any help will be greatly appreciated...it's taken 2 days to get this far.
Sincerely,
And Thanks
DS
The code is this so far...
Private Sub ListMain_Click()
DoCmd.Echo False, ""
DoCmd.GoToControl "SalesDetails"
DoCmd.GoToRecord , , acNewRec
Forms!Sales.SalesDetails!LineID = _
Nz(DMax("[LineID]", "SalesDetails"), 0) + 1
Me![SalesDetails]![ItemID] = Me.ListMain.Column(0)
Forms!Sales.SalesDetails!MenuNum = Forms!Sales!Text65
Me.Refresh
DoCmd.Echo True, ""
End Sub
This works really well...
I want to add another statement to it and I am confused.
I added 3 new yes/no fields that I need.. they are
Taxed
Inclusive
No Tax
I want to loop through the records after a new item is present and if
the [Location] field (Located on the Subform "SalesDetails"} = "Bar"
Then if any Records or Items are "Taxed" then all of the "Inclusive"
fields will become false and the "Taxed" field for that record will
become true.
Any help will be greatly appreciated...it's taken 2 days to get this far.
Sincerely,
And Thanks
DS