I am using a couple of command buttons to 'flick between' data entry screens, and have used various .visible .enabled etc on a number of the fields; I am using Case statements in VBA to enable the .value of options boxes BUT I don't think my problem has anything to do with these areas.

When I attempt to move from a screen I've been entering data to, to another form (screen) I can enter the data to the form BUT once I attempt to add the data to the underlying table the keyboard hangs and doesn't respond - after a moment on checking with CTRL-ALT-DEL the list shows Access isn't responding. Also the INSERT into SQL hasn't worked - this is implemented from clicking on a command button.

Any ideas folks?