StuLux
Well-known Member
- Joined
- Sep 14, 2005
- Messages
- 679
- Office Version
- 365
- Platform
- Windows
I'm not sure if I am trying to do something impossible or whether I am approaching the problem in completely the wrong way:
I have a form which is designed to be completed and printed off for signing. There is a sub-form which will detail any risks that are open and I have placed a text box that states that if there are any open risks they will be listed, if there are no risks the sub-form is empty. I would prefer to make this a bit more intuitive and have the text box categorically state when there are no risks and, if there are live risks, how many.
I'm pretty sure I need ot use DCount but can I change the value of a textbox in this way or do I need some other form of control on the form? I didn't really want to store this number anywhere.
I have a form which is designed to be completed and printed off for signing. There is a sub-form which will detail any risks that are open and I have placed a text box that states that if there are any open risks they will be listed, if there are no risks the sub-form is empty. I would prefer to make this a bit more intuitive and have the text box categorically state when there are no risks and, if there are live risks, how many.
I'm pretty sure I need ot use DCount but can I change the value of a textbox in this way or do I need some other form of control on the form? I didn't really want to store this number anywhere.