Inventory software: help needed

[ph_jawad]

Dear members,

I have an issue. Suppose i add 3000 units of a product in my stock. Out of which i consume suppose 3500. The problem is that the database shows -500 balance. What should i do so that the database should not allow more than 3000 units to be consumed.



Thanking in advance,

[pbaldy]

I'd use the before update event:

http://www.baldyweb.com/BeforeUpdate.htm

in your case, you'd check the amount about to be entered against the balance via DSum(), recordset, etc.

[orange]

I agree totally with Paul. I would also recommend that, before you get too deeply involved in operational aspects of Access, you identify the transactions involved in your "business" and document the logic involved. Then create the appropriate code/forms/validation/messages in Access and test things thoroughly.

I would also suggest you adopt a naming convention that uses alphanumeric and "_" only, with no embedded spaces or special characters. You will save yourself a lot of frustration.

[ph_jawad]

Many thanks for your comments. Im not good in VBA. Where i would put the code?

[ph_jawad]

I'd use the before update event:

http://www.baldyweb.com/BeforeUpdate.htm

in your case, you'd check the amount about to be entered against the balance via DSum(), recordset, etc.

Dear member,

I have enclosed my tables and query from my inventory software. plz guide me where i would put the code and what it would be. Thanking you in advance