MsgBox Alert

[daveyy]

Hope you guys may be able to help

I have a form with a sub form. On the sub form I have #Ordered, #Supplied & #Used. These fields calculate to give the user the # in stock. This figure is displayed on the form. On the form I also have the Reorder level which is set by the user.

I would like to be able to make a message alert pop up when the database is opened or when any of these records show the # in stock is lower than the Reorder level, ensuring that we do not run out of stock.

Many thanks for any help you can give.

 

[Malcy]

Hi
What about doing a query that identifies any records where your alert conditions apply. Then build a form based on that query to show the details of the problem lines (may be more than one so make it a continuous form).
Now put in something along the lines of

varAlert = DCount("a field", "MyQuery")
If varAlert > 0 Then
Open MyForm
EndIf

It would be worth putting a control on the form so that you can go straight to a re-order form.
You could either have this on the database opening screen or at any other relevant point in the database.
Any help?