How to intercept even in the Navigation Button

[NewAccessUser]

Hi, I'm using the Navigation Button at the bottom of the form to browse
record in a table. In the table, I have various flag and option and it is
currently simply displaying them as a numeric number. I'd like to translate
them into a meaningful text. This means that I've to intercept the record
and translate the number into the text appropriate to the data.
For example. I have a table "MyData" with a field "Active" which contains
the following displayed in a form "frmShowData". I'd like to turn on and off
a set of mutually exclusive option buttons - OptYest and OptNo.
1 for Yes. Would like to turn on an option button labelled OptYes also
turn off OptNo
0 for No Would like to turn on an option button labelled OptNo also
turn off OptYes

Can someone please show me how I can:
1 - Intercept the next or end of record event (i.e. when I click the left or
right triangle of the Navigation Buttons.
2 - code to pick up the value from the record and turn on and off option
button

Thanks in advance for your assistance.

 

[Rick Brandt]

Hi, I'm using the Navigation Button at the bottom of the form to
browse record in a table. In the table, I have various flag and
option and it is currently simply displaying them as a numeric
number. I'd like to translate them into a meaningful text. This
means that I've to intercept the record and translate the number into
the text appropriate to the data.
For example. I have a table "MyData" with a field "Active" which
contains the following displayed in a form "frmShowData". I'd like to
turn on and off a set of mutually exclusive option buttons - OptYest
and OptNo. 1 for Yes. Would like to turn on an option button
labelled OptYes also turn off OptNo
0 for No Would like to turn on an option button labelled OptNo
also turn off OptYes

Can someone please show me how I can:
1 - Intercept the next or end of record event (i.e. when I click the
left or right triangle of the Navigation Buttons.
2 - code to pick up the value from the record and turn on and off
option button

Thanks in advance for your assistance.

There is no event that is fired when you press the navigation buttons but there
is an event that fires whenever your form loads a record. It is the Current
event. In that event you can test the value of any field and set properties for
any control as desired.

I don't have any idea what you mean when you say you want to "turn on" an option
button. It sounds like you could have an option group frame with two radio
buttons in it bound to your Active field and the radio buttons would follow the
value of that field with no code required at all.

 

[Larry Daugherty]

Look in Access Help for "option group"

HTH