If Then different form

[troix]

in VB, i need to create an If..Then statement

On the form "PAGE7" is a field "Med55"
on the form "PAGE8" is a field called "Med76"

If Med55 is "1" then Med76 needs to be disabled.

Being Med76 is on a different form, how would I writ the statement?

 

[Girn13]

Try this:

If Med55 = "1" then forms![page8]!Med76.enabled=false.

My syntax might be a little screwed up but that's it.

 

[troix]

Doesn't work. already tried that 1,000 times.

 

[PHV]

Doesn't work
Any error message ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[RoyVidar]

And, to prevent us trying out the same things you've tried, consider posting what you've tried - i e current code, different attempts - and a also from where (which form/subform) you're attempting to do this, and which event (see one of the faq's in PHV's signature on how to get the best answers...).

Meanwhile take a look at How to refer to a control on a subform or subreport in Access 2000 which should hold the answers to this question.

Roy-Vidar

 

[Girn13]

Is page8 Open? Here's some code I have used.

DoCmd.OpenForm "Add Dependents"
Forms![add dependents]!txtHiddenCategory = 3
Forms![add dependents]!cmbRelCde = "ch"
Forms![add dependents]!lblInstr.Caption = "Enter new dependent's Information