totally guessing, but something like

lblPallet.Caption =
Format(Application.Sumif(rngA,txtPallet.Text,rngB) ,"#.##0")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jennifer" wrote in message
...
Hey all,
I need your expert help. I have created a form (with all of your wonderful
help of coarse) anyways, when the user types in a pallet # I would like a
label to diplay the remaining boxes available on the pallet. It would need
to
look in the database and perform a sumif function.
Any advice?
Thank you!
--
Though daily learning, I LOVE EXCEL!
Jennifer