If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
macro help
I have a "customers input form" for entering name, address, ref no.,
etc. I have an "order form" with a text box into which can be manually entered a customer reference number when needed. Next to the box is a button that when activated opens the "customers input form" displaying the customer details. The macro for the button is: OpenForm form name, customers input where condition, ="[CRN]=" & [CRN] This works fine, except when the button is activated and there is nothing in the text box, there is then a syntax error and the macro has to be stopped manually. Question is; what do I need to add to the macro to prevent the error happening when the text box is empty and the button is activated? Thanks. -- mick |
Thread Tools | |
Display Modes | |
|
|