Recent content by Miles Chandler

Pat Hartman, thank you for your advice and assistance. I appreciate any guidance and advice I can get as I am very new to the VBA side of access.

The problem seemed to be caused by the enter keypress to clear the message box. By adding that to the if statement it would appear to have rectified the issue. I have not yet encountered any other problems from this but it is still under development so might have other issues down the line...

Got it thank you. All’s that was required was to include "Enter" key press into the key press if statement. Thank you for the assistance.

Hello I am currently building a form that requires a number to be entered to recalculate stock amounts. I have managed to get it all working and every time the stock goes below 0 a msgbox comes up to state "Insufficient Stock". However when this occurs it triggers the msgbox "You Must Enter...

Hello, as stated I have just joined. Additionally I am still rather new to the use of VBA in access.