confirming AND navigating through forms

[Donkeygirl]

This is two fold. I have these records that we will sift through a list box to get to, but I also need little cmd buttons that will jump to a specific place in the list. ie. these are by legislative town or city. (LT) we want to be able to jump to the beginning of the lt 06 , or 21 and so on, as needed, also to have next previous buttons to go back and forth through them. Here is where it gets difficult( lol). I need to have the user confirm the changes they make to each record, and if they don't to not make the changes to the record.
The thing is that the changes they make are to option groups and check boxes. Their nature is to automatically store the click as a data value into the table as it is clicked. How do I enforce confirmation, and mabe even show the changes on a message box form in this process?
Thanks so much.

 

[DougAtAvalon]

What I did was create a function that is called in the before update events and have its return value be a boolean

Sub Control_beforUpdate(Cancel as integer)
cancel = FunctionName (argument)
End Sub

Function FunctionName (argument)

evaluate argument
if .... then FunctionName = Truee
if .... then FunctionName = False

End Function

 

[Donkeygirl]

Thank you. I will have to look this up to understand the syntax, but it is a good suggestion. I will post my other problem here too, although I must put it over in forms, since it belongs there. If you have any thoughts, let me know. :-s

I was almost set with this onopen statement of the form, but now it is all screwed up. The idea is that I need to det two option groups on the form to null --> ME![opgrp] = Null and to fields to where I want them, so that the form will show that record on start up.
Me! [LT]= "06"
Me! [LT] = "001"
This was working for a while when there was a DoCmd.GoToRecord in the first line. Then the goto stopped working and the form could not match the code to the statment. Ahhhh. I am still trying to figure out how I can set this form on open to have those settings of null option groups and the record showing at the first one. If you can help here, that would be great.
Thanks