Update Form on Using Navigation Buttons??

[Jozshi]

Not very good at explaining so you will have to bear with me.

I did create my own navigation buttons, and on clicking 'Next' OR 'PREV' etc etc it would check something on the form for me and enable/disable a control dependant on the result of the check, but due to later errors I had to continue without them and use the MS Access default navigation buttons (always located at bottom left BAH!).

Anyways, my problem then comes from the fact that I know longer now how to activate the check on the form now, due it now using MS default ones.

Does anyone know a way round this?

I have tried many different ways, even desperate ways (i.e. after update on the form etc etc .....well, you never know ).

If you could help that would be very much appreciated!

Thanks!

- F8i
Programmer
e: f8i@f8i.co.uk

 

[Maquis]

Hmmm, have you tried putting your code into the on_current event of the form? This will run your code whenever you move to a different record.

If your enable/disable process is also dependent on a control on the form which the user can update, then you can also put your code in that control's after update event. Maq B-)
<insert witty signature here>

 

[Jozshi]

Thanks very much Maquis!

The solution worked and was very much appreciated.

- F8i
Programmer
e: f8i@f8i.co.uk