filter Records in Data Entry Form

[desireemm]

Hi guys, I have an ADP Access on the Front SQL on the back and I want to make it so that every time the users open the form to either enter data or look up a record, all the records dont load. How would I do that, cause with all the records loading it makes access run so much slower, takes too long for the form to open

Any suggestions??

 

[pbaldy]

For data entry, use the appropriate DataMode argument of OpenForm. To load with a specific record, I'd have the user enter the ID/date/whatever on another form, then use the wherecondition argument of OpenForm to open the form restricted to that record.