Recent content by Amit jha

T Thanks for your kind assistance ... it worked with small change val = DLookup("Ser_charge", "Service_Charges", "Service_Type='" & sert & "' AND Engine_power = " & engp & "") and defined val as currency

Thank you so much sir .. someone assisted with this and that worked .. thanks again for your kind assistance . val = DLookup("Ser_charge", "Service_Charges", "Service_Type='" & sert & "' AND Engine_power = " & engp & "")

now its not showing any error but value shows null Me.Service_Charge_cr_.Value = DLookup("[Ser_charge]", "[Service_Charges]", "[Service_Type] ='sert' & [Engine_power] = 'engp'")

Hi Friends, My self Amit jha from India . i am just beginner and has lot of interest in learning Access . i have a query which i have posted request you guys to assist.

Hi There, i am not expert in access but trying to do something with Dlookup but not sure getting error with my requirement is to get service charges if i am entering this two text and combo box value by using Dlookup . kindly assist. Dim val As Double Dim sert As String Dim engp As Double...