Previous Thread

7/30/2006 7:24:01 AM    How to intercept even in the Navigation Button
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.



7/30/2006 7:50:56 AM    Re: How to intercept even in the Navigation Button
Look in Access Help for "option group" 
 
HTH 
 
-- 
 
-Larry- 
 
-- 
 
"NewAccessUser" <NewAccessUser@discussions.microsoft.com> wrote in 
 
message news:83871F99-0BE1-4E78-9BEE-7F1B20B1F70A@microsoft.com... 
 
browse 
 
it is 
 
translate 
 
record 
 
contains 
 
and off 
 
OptYes also 
 
also 
 
left or 
 
option

7/30/2006 2:32:11 PM    Re: How to intercept even in the Navigation Button
NewAccessUser wrote: 
 
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. 
 
-- 
 
Rick Brandt, Microsoft Access MVP 
 
Email (as appropriate) to... 
 
RBrandt   at   Hunter   dot   com