Subform and Master form problem

[Beeyen]

Good Day,

My dilemma here is how to code the following scenario in the event procedure
of the EmployeeName combo box field on a subform using results from a
selection on the master form: The label Claim Monitor [EmployeeName combo box
field] where the EmployeeName combo box field is activated to select an
EmployeeName only when one of the three conditions (Rate, Accumulation or
Co-pay) is selected from a combo box field on the Master Form called
[WorkCategory], else the field is grayed out.

The label Claim Monitor Start [Date/Time field] [Check Box] The Date/Time
field is populated when the Check Box is selected

Claim Monitoring Complete [Date/Time field] [Checkbox] The current Date/Time
populates with the checked box, if the Claim Monitor [Date/Time field] is
populated.

Any assistance or advice is much appreciated.

Thanks

 

[ruralguy via AccessMonster.com]

When you say label, do you really mean Control? Like a TextBox maybe? Are you
having trouble referencing the SubForm? If so then this link should help:
http://www.mvps.org/access/forms/frm0031.htm

Good Day,

My dilemma here is how to code the following scenario in the event procedure
of the EmployeeName combo box field on a subform using results from a
selection on the master form: The label Claim Monitor [EmployeeName combo box
field] where the EmployeeName combo box field is activated to select an
EmployeeName only when one of the three conditions (Rate, Accumulation or
Co-pay) is selected from a combo box field on the Master Form called
[WorkCategory], else the field is grayed out.

The label Claim Monitor Start [Date/Time field] [Check Box] The Date/Time
field is populated when the Check Box is selected

Claim Monitoring Complete [Date/Time field] [Checkbox] The current Date/Time
populates with the checked box, if the Claim Monitor [Date/Time field] is
populated.

Any assistance or advice is much appreciated.

Thanks