Setting state of controls by record...?

[Maldini]

Hi,
I know its possible to set the state of a form, so if condition A is true then I can set combobox A on enabled.

However, would just like to ask, is it possible not to apply this to the form forever? Rather, if my user were to cycle through the records with the default record selector bar (at the bottom of the form), I'd like the state to change.

So in record 1, condition A is true, so combo A is enabled.
But when the user goes to the next record, say record 2, if condition A is false, then I want combo B to be disabled.

In essence, I'm trying to get the states to change along with the record.

Any tips on how to do this? Thanks.

 

[psemianonymous]

You're looking for the Form_Current() event. This will trigger every time you hit a new record (when the form loads, when using your wheelie mouse, etc). You can set all those properties in the Form_Current() event. --
Find common answers using Google Groups:

http://groups.google.com/groups?group=comp.databases.ms-access