Recent content by FahadTiger

thanks to All for advising

that is what I will do it

yes.. i was do it in one my db... or i will make one form

There is relationship between main and subform .. i used this code on load event in main.. Private Sub Form_Load() Me!PurchaseDetailF.SetFocus ' Set focus to the form first Me!PurchaseDetailF.Form!ItemName.SetFocus ' Set focus to the ItemName field inside the subform End Sub

Hi... I have a customerNamer field in the main form ..When the user makes a mistake and does not enter the customer name... Of course the ID of the main form does not change And when I enter the itemName in the subform... Then I notice that I did not enter the customer name in the main form...

I Know that to use docmd.RunSQL " UPDATE..." thanks for your response

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

thank you ..its fixed from @June7

i did that and enter a new item in subform and give the last price=0 ..and that what I need ..thank you

thank you so much @June7 ..its working perfect

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...

Thank you All for response ...I dont Know why Im not use NZ Its perfect Now

this is my sample.. when No currency type in Euro gave me Error

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...