Toggle Button

[arunakumari02]

I a grid and a toggle button.

I have 3 tables.tblResource, tblNeed, tblAvailable

When I press on togglebutton(TRUE), the information should be displayed in the grid from tblAvailable. This information should be hidden when we again press the toggle bar(i.e toggle button is FALSE)
and the information from tblNeed should be displayed in the grid.

When Need is greater than available it should change the color in the cell when togglebutton is FALSE.

Please check the attached sample and would appreciate any help.

 

[khawar]

Download the sample and check form toggle2

 

[arunakumari02]

Can you help me with the database I posted i.e."toggle" because my form is very similar to that form.

 

[khawar]

The solution i posted is the easiest way to do it you can ammend it according to your data

 

[arunakumari02]

I also have horizontal scrollbar, as I move the scroll bar it moves months.

For example: Jan ... Dec , Jan ...Dec.

So I need 100's of Fields in the table.

Any help?

 

[dkinley]

Added another query to khawar's post to give you the color change you wanted.

It's not perfect since there is no indication of the amount of data or final structure (I use a count function assuming a 1to1 relationship) but this example shows how to loop through controls changing the color based on a decision made of inputs.

It should be enough to give you a gist for final rendering of the query.

-dK