Events

[Paul]

I have a tickbox on a form, that must grey out 3 fields
when it is ticked and ungrey 3 fields when it is unticked.

This I quite simply did with the On-Click event of the
tickbox. Great.

When a user opens the form it can check the tickbox and
accordingly deal with the 3 fields' .Enabled status. So
this is also dealt with.

The Problem: The next and previous record buttons at the
bottom, navigates between records. I don't know which
events gets fired when the user navigates with these
buttons, hence, I cannot set .Enabled = False/True for
those 3 fields, as the user navigates.

Please tell me which events fire as the user navigates
the recordset, so that I can deal with it.

Sincerely,
Paul.

 

[John Viescas]

Paul-

You apparently are performing the check in the form's Open or Load event.
You need to move that code to the Current event so that the code runs each
time the user moves to a new row (including the first one).

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)

 

[Paul]

John, thank you so so much, worked first time.

-----Original Message-----
Paul-

You apparently are performing the check in the form's Open or Load event.
You need to move that code to the Current event so that the code runs each
time the user moves to a new row (including the first one).

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out" (coming soon)
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)



.