Search results

Ok fellas. Thanks again for the reply. Here's the code Private Sub TabSetBooks_Change() '--- Calculate Credit Card Fees ---' Dim Amount As Currency Dim CCfeePct As Double Dim Fees As Currency CCfeePct = DLookup("[Number]", "BooksSettings", "Item = 'CreditCardFeePct'")...

Thanks for the reply, jdraw. I checked the value, and having a table column named Number seems to be fine, pulled the value that I wanted correctly. The error comes when I try and define the value for the variable Amount from a text box on a subform. the text box is a sum. I think that...

Greetings all I have a bit of code that is returning a 2427 runtime error and Nz() will not fix it. Was wondering if anyone could shed some light... Here's the setup: I have a subform that displays query results. At the bottom of the subform (in the footer) is a text box with control source...

Thanks a bunch RG! Just what I needed.

Greetings all, First Post time! but there's a first time for everything. I have a continuous subform (BooksFullSubCC) that is located on a tab in the main form (BooksFull). In BooksFullSubCC, there is a text box in the footer that sums up all the amounts of credit card charges to make a...