2 problems

[eran185]

hey
i have 2 problems :
1-i can fill only the first line in the form
2-i want to use "quantity - min" table : i want that if the quantity in the big form will be less then the quantity in the "quantity - min" table - that product will be in red

 

[giladbr]

Re: 2 Problems

Hello Eran,

1-i can fill only the first line in the form

That's because your fields in the form are not bound to a table. You must have a table that stores the data entered in the form. Set the "Control Source" property of your fields to the desired fields in the desired table. Then you will be able to have multiple records.

2-i want to use "quantity - min" table : i want that if the quantity in the big form will be less then the quantity in the "quantity - min" table - that product will be in red

I'm not sure about this one but I think you should use "Conditional Formatting" for that... The problem with continuous forms is when you change the font design of the field, it changes the whole column...

Good luck!

Gilad (Techi Medinat Yisrael)

 

[eran185]

clarification - what i want ...

i want a list of products.
every product has date and quantity .
also - every product has a minimum (if there is lwss then the minimum - i want to see that product in red)
i have a big list (quantity - min) , but not all the products are in the big table (big).