Search results for query: *

Why not set the combo box to use a query based on the table? This will allow you to use concatenation to create a column with the full name in it, as well as allowing you to add a second column with that tables unique id in it. Then use the unique id as the 'bookmark' for the on update event...

OK, read the thread to date, this may help, or just confuse and hinder so feel free to ignore me. Add a new field to the datatable, a yes/no for preference. Set the on update event for the 'new job' control to change the yes/no field from its default no to yes. This is easily done by putting...

Fizban Doh!!!!!! You sanity saver you. It was the break on all erros option..!! I was going daft trying to work out the error in the code. Doesn't explain why some errors were handled though.... Still problem sorted, mystery solved. Thank You

Don't know if this is the solution you want, but pressing the F7 key launches the spell checker and checks whatever control you have active. Could be an easyfix if all you want to do is check a single memo or text field. Ian

If all you want to do is warn them to be careful use the 'on got focus' event to trigger a message box with the relevant warning. If you want to get them to check the entry the have made use the 'on update' event, or one of the other events that run after some activity to trigger a message box...

Tony Thanks, but this is the code I've got in place, after reading the FAQ. I've also tried a Select Case variety of the trap as well, bth varieties result in the option to end or debug the code. Private Sub RejFollowUpBtn_Click() On Error GoTo ErrHandler DoCmd.OpenForm...

Hello All I've got a problem with a database I'm working on. Certain users are not allowed to open some forms, when I test this I get the 2603 error message and the option to end or debug the code. Now I don't want the users to have the option to debug the code, they might do something silly...