Solved Trying to satisfy 2 conditions (1 Viewer)

[Sam Summers]

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

 

[theDBguy]

I think you need separate conditions like:

If Me.Remaining > 0 AND Me.CurrentStock <= Me.ReorderLevel Then

However, when would remaining and current stock have different values?

 

[LarryE]

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.


View attachment 110827
Should be simple i know but i just can't see it!

Many thanks in advance

Try:
If Me.Remaining >0 AND Me.Remaining<= Me.ReorderLevel OR Me.CurrentStock >0 AND Me.CurrentStock <= Me.ReorderLevel Then

 

[Sam Summers]

I think you need separate conditions like:

If Me.Remaining > 0 AND Me.CurrentStock <= Me.ReorderLevel Then

However, when would remaining and current stock have different values?

There was a reason why i created it that way but cant remember now it was to do with the numbers changing within the calculation - just remembered why. It was because the remaining value was not saving in the table on form close so created the CurrentStock field to do that.
There is probably a better way to do it than how i have.

 

[Sam Summers]

Try:
If Me.Remaining >0 AND Me.Remaining<= Me.ReorderLevel OR Me.CurrentStock >0 AND Me.CurrentStock <= Me.ReorderLevel Then

Looks like that has done it. I'll complete the testing and post here in a minute.

 

[Sam Summers]

Thanks guys. It is mainly sorted. Still having a bit of fun with the way it functions but your help has fixed that main issue.
This tiny little thing has been one of my worst nightmares to get right!