Access Gui SqL Server 2000/Need a Filter

[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

 

[JohnDTampaBay]

Sounds like you tied the form directly to the table. You can write a query that pulls a single record, then tie the form to the query. You would probably need parameter in the query that specifies which record to pull, maybe the primary key value from the table (for example, Account_Num). I hope this helps. Good luck!

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)