Recordset navigation with command buttons

M

Mike

Hello,

I have an unbound form which I'm using to display data from a
RecordSet. Is there a way to use a command button to navigate through
the RecordSet records? I'd like to add a 'Next' button, but can't
figure out the code I need to control the navigation.

Thanks,
Mike
 
S

strive4peace

Hi Mike,

firstly, why are you using an unbound form? This greatly
complicates things...

What is the SQL for the recordset you are displaying from?
You could use the Bookmark property to find the record in
your code using a recordset object, then the MoveNext method
to move the record, then write the fields for the record
your move to to your form... but this is really the hard way
to go about it!


Warm Regards,
Crystal
Microsoft Access MVP 2006

*
Have an awesome day ;)

remote programming and training
strive4peace2006 at yahoo.com

*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I figured out the issue thank you. 0
Program buttons to create a word document 0
Optionbutton Not working 3
Getting Radio Buttons to work, that are inserted via AutoText 0
Adding records without navigation buttons 4
Recordset.Clone Help Needed 9
Dynamic Naming of Form Button 3
Filter main form to records with no related records in subform,maintain updateable recordset 4

Top