Hi everyone,
I'm new to Access & VBA and I would appreciate some help! I've put a little bit of code in the 'on load' event of a subform so that when the form is opened and there are no records to show a message box appears to say something along the lines of 'sorry no information to display'. This was working fine until I changed the text to appear in the message box-now I get two message boxes, one with the old text appearing and one with the new text appearing. It's driving me crazy-I don't know why it should do this, can anybody help?
I'm new to Access & VBA and I would appreciate some help! I've put a little bit of code in the 'on load' event of a subform so that when the form is opened and there are no records to show a message box appears to say something along the lines of 'sorry no information to display'. This was working fine until I changed the text to appear in the message box-now I get two message boxes, one with the old text appearing and one with the new text appearing. It's driving me crazy-I don't know why it should do this, can anybody help?