Replies

Thanks, Steve!

Good point! I’ll let the programs people know and see what they want to do…I don’t think that they have thought of that either.

Thanks!

Hey, thanks anyway, Jerry. The more variations I get, the more I learn for next time…nothing’s wasted…so Thank you!

Thanks again, Hans…(for this VBA version). You are truly an Excel guru

Thank you very much!!

It seems so simple now that I look at it…why couldn’t I think of that

I really appreciate your help!

This spreadsheet will be going to users who don’ t know VBA at all (I know a little) so the Excel version would likely be best.

If you have the time, I would like to know the VBA version as well.

Thanks,

Christa

Thank you! That was my problem (I obviously have not done this for awhile

Thanks again

Christa

The hosts file?…how do I do that?

Thanks,

Christa

You are a lifesaver!!! Thanks!

I’ve figured it out…the formula works as long as there is already a record for the particular item in the Used table. If there is no record in the Used table for the item, the quantity on hand doesn’t show eventhough there is a quantity on hand in the Receipts table. I would like it to just pull the total number from the On Hand query no matter what records are in either table (Receipts or Used). Can this be done?

Thanks,

Christa

A stripped down version of the database is attached. Thanks for all your help.

I don’t get any error messages…the field just remains blank.

Thanks,

Christa

This morning I copied the formula you send into the Control source of a new text box and the quantity on hand came up…it worked perfectly!…however since then I’ve added some macros to open forms and a switchboard…and now it no longer works. I haven’t changed any of the fields that the On Hand query refers to…any ideas?

Thanks,

Christa

Thank you so much!!!

Thank you very much!