report problems

[pigsy101]

i have a check box whose control source is:

=[Total In Stock]-[reorderlevel]<=0


how can i set the control to only be visible if this check box is
true?


tried macro and vba, but can't quite work it out.


thanks in advance


Paul

 

[Guest]

Try the code:

Me.[CheckBoxName].Visible=([Total In Stock]-[reorderlevel]<=0)

The code above should run from few events:
OnCurrent event of the form
AfterUpdate event of both fields: [Total In Stock] ,[reorderlevel]

 

[Guest]

Sorry, I just noticed that you mentioned a report

Use the code in the OnPrint event of the section where the check box is
palced in

--
Good Luck
BS"D

Try the code:

Me.[CheckBoxName].Visible=([Total In Stock]-[reorderlevel]<=0)

The code above should run from few events:
OnCurrent event of the form
AfterUpdate event of both fields: [Total In Stock] ,[reorderlevel]



--
Good Luck
BS"D

i have a check box whose control source is:

=[Total In Stock]-[reorderlevel]<=0


how can i set the control to only be visible if this check box is
true?


tried macro and vba, but can't quite work it out.


thanks in advance


Paul