Hi
I'm trying to setup navigation buttons on a form for a user to scroll through the records.
I have created a recordset and want these button to be updated when at bof or eof. I have used a data control in VB and put the code in the reposition event. But I don't know how to do this in Access VBA can anyone help? There doesn't seem to be a reposition event for a recordset.
G.

You can use the button wizard to create these buttons for you, which will help if you are no completely comfortable with the code behind them.

I have created the buttons but I want to disable some when the recordset is at bof or eof. But I need the code to check which buttons to enable or disable each time the recordset is moved. I have done this in the reposition event of a data control in VB but not sure if this is possible to do in Access.

try this link
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=44199

alternativley create a custom toolbar and use the standard buttons from the records toobar, they work as expectd.

Peter

Thanks for the link to the thread, just what I was trying to do. Thanks to you all.