Ms Access HElp Reposted

[Simon Glencross]

Allen,

Thank you for you help I have managed to get it up and working!!

Can I ask you another questiong re your AppInventory?

I was to create a report based on the stock tootals created what is the best
way of doing this as the code which you provide requires for you to enter
the prouct code in order to get a total.

Any advice is much appreciated!

Thanks again

Hi Simon

I take it that:
a) You have this code in a standard module (one that can be reached
through the Modules tab of the Database window.)

b) It compiles okay.

c) You get the correct quantity returned for product 99 when you open the
Immediate Window (Ctrl+G) and enter something like this:
? OnHand(99)

d) You have a form bound to a table/query that has a ProductID field, and
on that form you have a text box with Control Source:
=OnHand([ProductID])

Can you verify that these assumptions are correct, and indicate what
result you get in the text box: e.g. blank, #Error, other?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

OK, well I shall wait and hope Alan responds......

Thank you