Lost Newbie.....Please help.

[beachbumch]

Hello. I am still new to the access world and have made it to the end of a small inventory database I wrote for our company. Of course right before its complete I run into the biggest problem Ive had through the entire development. Im trying to run some calulations and keep getting #Name? where I would expect the calculation to be. I can also get #Error in the same field when my expression is written incorrectly. The expression I have so far is:



=Sum([tblPOInventoryTransactions].[QTYReceived])-([tblSOInventoryTransactions].[QTYShipped])

This expression is in a text box on my main form. tblPOInventoryTransactions and tblSOInventoryTransactions are both tables with subforms on the main form. All I need to do is subtract QTYshipped from tblSOInventoryTransactions and QTYReceived from tblPOInventoryTransactions and have the results displayed on the main form.

Any guidance here would be greatly appreciated! Thank you.

[beachbumch]

Ok, after reading through this forum, it seems I need to rethink this and use a query. Im going to play with that idea for a few and report back. Thanks!

[orange]

Inventory databases can be complex. Can you post a jpg of your tables and relationships?
I have Access 2003 so can not open or read an accdb file.
You may wish to post a copy of your database for others to review.

This link may help you with form subform controls syntax
http://access.mvps.org/access/forms/frm0031.htm

[beachbumch]

Yep, problem completely fixed using a query. I just needed to rethink what I was doing. Thank you for the help. Just searching through past posts was enough to get me in the right direction.