You could use a script to SAVE and then set subform B visable property to NO and the subform C to YES, but you might also consider using a TAB with each sub form on a different TAB
I like to use:
MyVariable = Dcount("QueryFieldName","MyQueryName")
Then you can 'If' or 'Select Case' on MyVariable
(it will contain a 0 if there are no records...)
If you really want to "trim" off the excess decimal places, use this:
Function RoundCC(X)
RoundCC = Int(X * Factor + 0.5) / Factor
End Function
Use it like MyNumber = RoundCC(MyNumber)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.