Sam Summers
Registered User.
- Local time
- Today, 15:14
- Joined
- Sep 17, 2001
- Messages
- 939
Hi Everyone,
I just cannot get my head round this one and the more i try the more confused i am!
I have to open a form to warn us to re-stock.
So i am setting it for the Form - On Load event and also when the remaining level goes below the reorder level.
So i need to create something like this:
If Me.Remaining.Value And Me.CurrentStock.Value >0 and <= Me.ReorderLevel.Value Then
DoCmd.OpenForm etc. etc.
Should be simple i know but i just can't see it!
Many thanks in advance
I just cannot get my head round this one and the more i try the more confused i am!
I have to open a form to warn us to re-stock.
So i am setting it for the Form - On Load event and also when the remaining level goes below the reorder level.
So i need to create something like this:
If Me.Remaining.Value And Me.CurrentStock.Value >0 and <= Me.ReorderLevel.Value Then
DoCmd.OpenForm etc. etc.
Should be simple i know but i just can't see it!
Many thanks in advance