split value of a record based on boolean value in form

[WStoreyII]

Hi its me the mattress sales man again making lots of
progress on my database but have hit another wall

on the form for the sales info i am trying to set it up
so that if the field SPLIT(boolean)if true will cut the
value of the subtotal of merchandise in half as i am
spliting this sale with someone else

i tried an if then function but then it will not let me
enter a sub total i need to be able to manually enter a
sub total and if i check split it will automatically cut
that in half

thanks again for all your help

 

[[MVP] S. Clark]

**Although the name of this newsgroup is 'Queries',
it is actually referring to the Access Database Query Object.**

You may want to visit the FormsCoding Newsgroup for specific help on VBA
coding within forms.

Finally, punctuation and capitalization go a long way in helping to get your
question answered.


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-