Search results

Ignore that, I am an idiot and didn't scroll.

Problem With Displaying Subform Field - Quantity Wrong Ok, new problem though ... Sometimes the quantity is correct, other times it's wrong. Eg. The first 3 records work fine. Number 4 has 4 units purchased and a total of 2 units sold so should be quantity of 2 but actually shows 6. Number 5...

Wiz, Thanks for the help and the feedback. You're a lifesaver.

Problem with Displaying Subform Field in Parent Here it is, nothing personal in it.

Appreciate the assistance, this is driving me crazy. I've probably made some basic error elsewhere. The relevant bits of the db are: Tables Stock StockID PK SupplierID CategoryID LocationID Name Brand Size ReorderLevel Inventory InventoryID PK StockID Date UnitCost UnitsPurchased UnitsSold...

Sorry, tried that as well and I still get an error.

I'm using Access 2002 but the file is 200 format so that they can use it on their computer. I tried each version but no luck. Still get #error or #name? error.

Hope you can help. Having problems displaying a calculated field in a parent form. I have a form Stock and a subform StockSubform2. In StockSubform2 I have a field (txtMaxUnitCost) calculating the highest cost of a number of stock purchases. The expression to calculate the highest cost is...

Tried it but still getting a #name? error.

Ok, having problems with a simple database I'm doing for a cafe. I have a form Stock (listing details of stock items) with a subform StockSubform2 (listing inventory movements). In the Stock from it lists the current quantity, the unit price and total value at hand. It's in the quantity control...