trouble..

[BlankReg]

Hi all, hope someone can help me..

I have a form on my database called "Stock Maintenance". The form has been designed so users select from two combo boxes one named "Part No" the other named "Descripton", once they have made there selection, there information appears in boxes ready for the user to edit.

The fields i have for editing are "Description, Components, Min QTY and QTY".

I have attached code to Min QTY and QTY, so when Min QTY is below 10, the box changed to Red and a message box appears asking if the user wants to send an email notifying the adminstrator that Stock QTY is low and more needs to be ordered.

Unfortaunelty, this code applies for all Part No's and Descriptions in the combo box.

What i'm after is a way that i can set each part no and description seperately:

example: Battery - (below <5) Front Panel - (below <15)

I've tried to express what im trying to do as much as possible;

any help on this matter would be greatly appricated

 

[Rabbie]

I am a little confused about your design. Surely there should be a description already associated with a part number so I don't see why you need two combo boxes. Once you have selected a partnumber then you can populate the fields on your form with description, Min QTY, QTY and any other fields you have.

 

[georgedwilkinson]

Apart from that, why don't you store the minimum in a table and do the calculation based on that minimum?