how to lock/disable a subsubform depending on value in a bound combo box in subform?

[Yousaf Shah]

Hello everybody
i am building my dataabse for patient record. my main record entry form "patients Record" is a tabbed form with tabsas follows
tab "NOK" having subform NOK,
tab "History/Exam" having subform History and subsubform Exam,
tab "Admission" having subform Admission

all the subforms are subform to main form "Patients Record"

Now on subform History, there is a bound combo box named "AdmNeed" with values; "Admission not required", "Admission required now" and "Admission required in future"

Now I want that if "Admission not required" is selected in "AdmNeed" combo box, subform Admission on tab "Admission" should be automatically disabled and if any of the other choices is selected, it should remain enabled...

can anybody help me..?

[NeoPa]

You need to cover a number of issues :

1. Referring to Items on a Sub-Form is something you'll be needing to get right. The Sub-Form control that a form is contained in can be referred to, from the code of the form itself, as .Parent.
2. Once you have determined how correctly to refer to one item from another, you need to set the .Locked or .Enabled properties of the Admission tab appropriately.
3. When to do it - Or where in your code?
   This is important. Not only should it handle when new records are displayed (The Current event), but it should also handle when the value is changed within a record (The AfterUpdate event of the control).

This should be enough to help you resolve the issue. If you need more then please specify clearly how far you did get when trying out these suggestions. Best of luck.