One Record at a time

[desireemm]

I was wondering does anyone know anything about having a record retrieved one at a time rather then all of them at once. I have a access xp front end on my database and sql server 2000 as the engine, when you open up the database it opens all the records including the picutres I have on the form and loads all this on to your desktop. Is there a way for the form to load empty and the users just call the records to their desktop rather them all loading all at once????


Know the Lord

 

[tc3596]

wrong forum...
Open the form in design mode and make the form unbound. (i.e. make the control source empty.) You will have to dymaically set the control source after the user has chosen his/her options.