how to page thru listbox items in a form's recordsource

M

mscertified

onI have a screen to specify search criteria and show the results of the
search in a listbox. There is a command button to edit the selected record.
Editing is done on a different form. I'd like the user to be able to press
Prev/Next buttons on this form to page thru the records listed in the listbox.
The current set-up is that the edit button does an OPENFORM with a WHERE
clause for the record id. The editing form has a recordsource for all the
records in the table (it also does joins) not just the listbox.
Is it possible to change the forms recordsource to be only the subset of
records in the listbox?
How can I best implement the prev/next buttons on the editing form?
 

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

Optionbutton Not working 3
Crating User Form to Add Names 1
Change Form's Recordsource with SQL Statement? 0
populate listbox form database table 0
Referring to multiple columns in a listbox 3
unbound listbox... how do i make the current record selected 4
Program buttons to create a word document 0
weird listbox behavior - just upgraded to Access 2007 1

Top