Hi my Expert..
I have button to select or deselect all OptionButton in continuous form and change its caption ...but its select just first OptionButton ..not all OptionButton
Private Sub cmdSelectAll_Click()
' Toggle the state of OptionButton1
Me.OptionButton1.Value = Not...
the user enter any new item from the combobox in the sub form and after update event I used function Dlookup to get me last price from the Query that you are did it for me..if new item i get value zero in the textbox of last price
Hello My Expert
I have tblPurchase with PurchaseID AS primary key and purchaseDate
and tblPurchaseDetail with PDID AS primary key and PurchaseID as number and ItemID AS number
and purchasePrice as currency...what I want the latest purchasePrice for each Item according to latest purchaseDate
any...
Hi Expert..
I used module to sum Amount according to CustomerNumber And CurrencyType
its working Good and give me the Result im main form of saleInvoice
but..when there are No Records in the table give me Error "invalid use of null".. in "TotalAmount = rs!TotalAmount"
How can I FIX that...
I think I was stupid in explaining this...
I wanted to count from the one in each invoice .. I was wrong in relying on the itemcod because it bears the number zero and is not null