WantToKnowMore
Programmer
I want to stop the user from exiting a record if a certain field is empty. I have 2 combo boxes that depend upon each other and if the user hits escape, the one box is ok but the other box will not requery. (The underlying record is fine and contains the value, it just won't display). So I thought I'd try to stop the user another way.
I found the form method 'RecordExit' in the VBA help which is supposed to pause the user's exit and allow you to check for errors.
I know that the method doesn't appear in the forms property sheet (the help indicated that there are some VBA available methods that aren't available on the Access side - If you don't click on the form's property sheet a method that you added in with code, the form isn't aware of the code for the method.)
My book doesn't say how to make it fire, and I assumed that it would on its own, but maybe not.
Any ideas?
Thanks much in advance!
I found the form method 'RecordExit' in the VBA help which is supposed to pause the user's exit and allow you to check for errors.
I know that the method doesn't appear in the forms property sheet (the help indicated that there are some VBA available methods that aren't available on the Access side - If you don't click on the form's property sheet a method that you added in with code, the form isn't aware of the code for the method.)
My book doesn't say how to make it fire, and I assumed that it would on its own, but maybe not.
Any ideas?
Thanks much in advance!
