This sounds like something that should be easy, but I just can't seem to get it working...
I have a form with a datasheet subform. I would like to have an unbound text box on the main form automatically display a certain value based on values entered in the subform.
For example, I am only concerned if the user were to enter "B" for one of the records in the subform. So if the user enters the following the following three records in the subform
A
B
C
I would like the text box on the main form to display "You have entered B". If the user does not enter B on the subform, it should display "You have not entered B".
How can I set the control source of the text box to analyze the records entered in the subform?
I have a form with a datasheet subform. I would like to have an unbound text box on the main form automatically display a certain value based on values entered in the subform.
For example, I am only concerned if the user were to enter "B" for one of the records in the subform. So if the user enters the following the following three records in the subform
A
B
C
I would like the text box on the main form to display "You have entered B". If the user does not enter B on the subform, it should display "You have not entered B".
How can I set the control source of the text box to analyze the records entered in the subform?
