Balance in a Inventory Database

[suradj]

Hi All,

i have created an inventory database. I used the code of Allen Browne(http://allenbrowne.com/appinventory.html).

Now i have to create a Form which shows me the balance and quantity on the most recent date.

I looked at the Inventory Sample of Allen Browne but can get further.

Can u help me to create a form on which i can see the balance and quantity

See attachment

thnx
Suradj

 

[Steve R.]

The zipped file was "corrupted", so I could not take a look at it. Anyway you need to read-up on how to design a form, including getting the fields populated from the underlying data. You may want to consider obtaining an Access reference books. If you have a specific issue that is causing you grief, that is something the forum can help you with.

 

[suradj]

I checked the zipped file. It's oke
I know how to create a Form etc.
But in my database i want a form with a field wich shows me the balance and quantity on the most recent date

I looked at the sample database of Allen Browne.

See attachment