i have form with fields
outlet no:
outlet name:
address:
stock:
(new) (save) -> command buttons
how can i validate
if the previous save record is equal(the same) or not with the new record
i need to count specific items in my list box and im having problem doing it..pls help
Item--------PO No
A -----------2000
B ------------100
C -----------2000
D -----------2000
E ------------100
THE OUTPUT...
tnx HiTechCoach....and sorry my reply is late
im using a crosstab query
***criteria from a form
begin date:3/1/2009
end date:3/31/2009
outlet---name----address----3/1/2009---3/2/2009----->
001-----xxx-----yyyyyy--------NB--------OS
002-----xxxx----yyyyyy--------NV--------OF...
im having problem with column sum with my listbox when the column have
null values....
1.no sum is generated when i have null values
2.error on this line ***
im using this module
Function ABill2() As Variant
Dim I As Integer, J As Integer, ctl As Control
Set ctl = Forms![formname]...