Reflecting form changes

[GC1CEO]

I have been puzzled with this for a while as I work on and off on a project, I want to have the ability to hit a button, have it change a value and to make changes to the forms. The closest option I have found is requery but it reloads the entire set of records and I don't want it changing the actual recordset position (or if neccesary to be able to go back to it immediately without the end user seeing thats what has happened).

An example is I have an option group of four buttons which are status of membership, depending on which one is selected I wish certain buttons to other subforms to be displayed or not displayed, likewise if I select another option button then I wish for the form's controls to update without having to do anything else but pushing that button.



Chris Green
Computer Information Systems Student
Cayuga Community College -- Fulton

 

[Spenney]

Hint: Take a look at the AfterUpdate event of the option group and the OnCurrent event of your form.

 

[TheAceMan1]

How are ya GC1CEO . . .

Have a look at the thread at the bottom of my post, and perhaps it will come to you, why your thread has gone unanswered! . . .

See Ya! . . . . . .

Be sure to see thread181-473997