RecordExit

[JoshuaAnthony]

I am using Access 2002 and I can't seem to make the RecordExit event occur. I saw a message on this board that suggested RecordExit event no longer exists?

Basically, I want to open one particular record for the user to edit and I don't want the user to be able to traverse (letalone edit) the other records. Does anybody know how this is possible?

At the moment, I have to have a workaround where the control bound to the relevant table entry is locked so that no edits can occur. Then if the user wants to make a change they have to enter it into an unbound control. I then have to copy the information from the unbound control to the correct bound control with vb code so that it doesn't matter which record the user is currently on. Any simpler ways to do this?

Thanks

 

[Rich]

Open a PopUp form, save the changes and then requery the original form

 

[JoshuaAnthony]

Thanks but wouldn't I have to do the same thing as I suggested, only in a pop-up form? I need the bound controls to show the user what they are editing (they may not need to change anything) and I need the unbound controls so that the user can enter data (since I have locked the bound controls). I want to make absolutely certain that the user can't accidentally edit records other than the one that loads with the form.

Would you mind being more specific with your suggestion if this wasn't what you had in mind please?

Thanks

 

[Rich]

I'm not sure what you're trying to achieve, if you open a PopForm with a single record and the ModalProperty is set to yes, your user cannot return to the original form untill they close the popup. You can also use the BeforeUpdate and Dirty property to test for/validate Edits. I don't see any advantage here in using unbound controls

 

[JoshuaAnthony]

Yeah sorry you are right,

I should have just used a query in the first place to open with only one record.

Thanks very much.

 

[Rich]

You don't actually need another query, just open the Form filtered, the Button wizard will create the code for you

 

[JoshuaAnthony]

Is it possible to remove all toolbars (including filters button) from user version of program - perhaps using autoexec macro??

 

[Rich]

A filter can't be removed from a Popup, Modal form with the shorcut menu disabled.