Search results

OK, here's what I did: 1. I created a text box named txtTotalCosts on the parent form 2. On the parent form, I placed the following code in the Form_Current() event (obviously, rename the [SubFormName] sections to your own sub form names): Private Sub Form_Current() Dim dblTotalCost As...

As expected, it shows the first SubTotal amount. I'm working on doing it via VBA and I'm having much better luck. Just a little snag I'm working through now: Since it's a subform, my loop errors out when there are no records associated with the parent form. But it works beautifully when...

Hello. I'm a fairly advanced .Net programmer and have a few years of experience with Access as well. I'm currently working on a complex Access 2007 DB for a customer and ran into a snag. Hopefully someone has seen this and can offer an easy work-around. I'll try to keep this as simple as...

IIf can't be used in VBA code blocks. You'll need to use VBA for that. Here's the code you want: IF txtInvoiceNumber <> "final" Then msgbox("text here") END IF If you're trying to do this in a control's Datasource property, then, yes, use IIf: IIf ("final","text...