Dear Gents,
I wrote a code snippet that loops through all records on an continuous form, This loop checks if the CurrentStock less than MinStock then change background of this particular product which match the if condition , But unfortunately it changes all backgrounds for all products.
Any help please ?Code:With Me.Recordset .MoveFirst Do While Not .EOF If CurrentStock < MinStock Then Prd_Code.BackColor = vbRed Prd_CurrentStock.BackColor = vbRed Else End If .MoveNext Loop End With