Search results for query: *

I have a comboBox that as row source of this: SELECT DISTINCT tblPerson.Member FROM tblPerson; names like davis, smith, jones will fill the form in with information about which name I pick. But a name like O'Dowd, does not fill the form in. The form stays blank. Thanks for any help in...

I have a iif function that does work. But I would like it to do more. Here is my iff function =([billAmount]-nz([ded],0))*IIf([ExpenseCategoryID]=3,0.5,IIf([ExpenseCategoryID]=7,"50.00",0.8)) This is the part not working right ([ExpenseCategoryID]=7,"50.00", I know why becasue I would like...

I have this code on a form, the me![percent] has a iff statment which is: =([expenseItemAmount]-nz([ded],0))*IIf([ExpenseCategoryID]=3,0.5,0.8) then I have this code on the form: Private Sub Form_BeforeUpdate(Cancel As Integer) Me![ckamount] = Me![Percent] Me![OONAmount] = IIf([OON] = -1...

This thread seems like something I could use but I don't understand where to put the code. Does it go on the beforeupdate on the form or the beforeupdate on the text box [CkAmount] I believe this is the right code: Me![CkAmount] = Me!Percent my table is tblbill my form is frmbill on the form...

Can someone help me with my iff statement =IIf([ExpenseCategoryID]=3,([ExpenseItemAmount]-[ded])*0.5,([ExpenseItemAmount]-[ded])*0.8) My problem is when [ded] is blank. Thanks for any help in advance