Formula doesn't work when copying dbs

[Indigobuni]

I have created a new inventory db based on our old one. It looks very similar with a few minor changes. In the old db, there was a formula in the subform that calculated the # purchased minus # used. In the main form, the Units in Stock referenced this formula.

I copied the formula exactly for the new db, but it doesn't seem to want to work. I can't see any vb code attached to the formula. This is frustrating. I'm also wondering if it's because they used an access template to create the old db, and I am doing the new one from scratch.

Can someone help or would be willing to look at the old and new db. I have eliminated most of the data... only a few things left in inventory to help guide me with the formulas, etc. The form in the old db is Products and Products subform. The form on the new db is frmProductEntry and subfrmTransactionDetails.

I would appreciate any help possible. We want to get started entering our real data. Thanks.

 

[alastair69]

Have a look and see if i have fixed it.

If you could let me know either way then i can offer more help on your forms.

Alastair

 

[Indigobuni]

Whatever you did worked. Could you please let me know what was wrong? Thanks.

 

[alastair69]

I think you got the subform name wrong, funny i cannot remember

 

[Indigobuni]

Ahh, I see what was wrong now. I had the reference to the formula in the main form incorrect. Thanks again.