My form [Menu] has a combo box where ClientID is remembered for later use.
I then open a form: frmClientEdit
WHERE Condition= [ClientID]=[Forms]![Menu]![ClientID]
Works ok. Except if the user fails to choose a ClientID from the combo box before opening the form, then a Microsoft Visual Basic error message appears: “ Run-time error ‘2105’. You can’t go to the specified record”.
This is indeed true. But I want to avoid the error message by verifying that user has used the combo box and a code has been entered in [Forms]![Menu]![ClientID] prior to opening frmClientEdit.
How do I do that within the macro that opens frmClientEdit?
I then open a form: frmClientEdit
WHERE Condition= [ClientID]=[Forms]![Menu]![ClientID]
Works ok. Except if the user fails to choose a ClientID from the combo box before opening the form, then a Microsoft Visual Basic error message appears: “ Run-time error ‘2105’. You can’t go to the specified record”.
This is indeed true. But I want to avoid the error message by verifying that user has used the combo box and a code has been entered in [Forms]![Menu]![ClientID] prior to opening frmClientEdit.
How do I do that within the macro that opens frmClientEdit?