Cabgolfer said:
I have a combobox with multiple selections (lets say A, B, C) and a blank
text box. When the user selects "B" from the combo box, I would like to make
the text box required. Can anyone help?
When would you need to know that it's required? When the form tries to
update the record? Before a selection in another control is made? If the
field in the underlying table is only required in some conditions, then
you'll need to determine when the check should be done and see if the
textbox contains a value. With more detail from you I could be more
specific, but in essence you would use the following in some event of the
form or other control....
If Nz(Me![TextBoxName],"")="" Then MsgBox "This box is required"
What happens after that depends on the unknown circumstances. Should it
prevent moving to another control? Cancel the update of the record? And so
on...