Total Credit not calculating

[tjones]

Still no totals. I ran it through debugger, the UnitTotal turned red, so I removed that hoping it would make the others work. No such luck.

 

[plog]

I'm not the best with forms, but I can get this to work. Maybe someone knows a better way, but I know this will work.

Change your input forms to labels and then change your VBA code to start with this:

Me!UnitTotalReq.Caption =

Me!UnitTotalCore.Caption =

Me!UnitTotalCont.Caption =

Me!UnitTotal.Caption =


You need to identify the form (Me!) the control (UnitTotal) and the element of that control. I don't know which element of an input box you need to use, but I do know the Caption element of a label is what you need to reference to get it to show what you want.

 

[tjones]

Ok now you lost me. I assume you meant turn the input fields (not forms) to labels but how you do that?

 

[plog]

Yes that is what I meant. To do that go into the form in design view, right click the input and select 'Change To' then choose Label.

 

[tjones]

Now i'm getting a run time error "13"

Type mismatch

 

[tjones]

The solution was found. Put the fields on the main form as unbound text fields and in the control souce reference the query as the control source with this. Thank You boblarson!

=Nz(Dlookup("[TotalCreditsReq]", "qryUnitTotalRequired"), "")