Continuous Forms

[mercury]

Hi

I have this database and it is supposed to list supplies,the amount of these supplies instock, four suppliers and the amount and cost for each product supplied by the supplier. The problem im having, is the highlighting of the highest prices. What is happening is that the same column is being highlighted for every record. I attached the database for those who dont understand what i just typed. Just open it up and click the highlight button. I just gave an example of two record but in reality they are hundreds and the update button which isnt working is supposed to update the instock field by adding on the amount that was ordered.

if any one knows how i could do all of this differently do tell.

Thanks

 

[mercury]

Thank you for your help

 

[mercury]

Hi

I tried what you suggested but it still isnt working correctly. What im trying to do is Highlight the highest prices in red. Could someone take a look at it.

Thanks

 

[mercury]

Hi

Thanks for your advice but im new to Microsoft Access and this is the best i could come up with

 

[mercury]

hi,
The reason why i choose this layout is because the guy that im doing the database for requested that he wants it look like a spreadsheet. Secondly with the companies i was told to do slots for only 4 companies and he wanted it so that he can edit the names but i do understand where u r coming from.

When u said that i should use Conditional Formating, i thought that the code i had would have worked because i tried it in a button and it worked perfectly but it was a single form.Since this is the first time im using Continous Form im just lost.What k9nd of code can u put in the conditional format?

 

[mercury]

Thanks for the advice, enlightenment and help.

I have one more question is there a way to perform simple calculations using a continuous form lets say to Increase the instock field in my database by the four Amount slots provided. I came up with the code but i want to know if there is a special feature like Conditional Formatting that could be used to put this code into or just place the code behind a button.



just wondering.

 

[mercury]

Thank you for all of your help it was greatly appreciated