SplitForm for DataEntry, Filter based on keystrokes

[sesproul]

Hello,



Is there a simple setting to either set the recordsource to requery based on the values entered into a textbox for PartNo with each KeyStroke.

So I was thinking of adding the code into the PartNo_KeyPress function, but how would I apply the filter, or change the Recordsource.


the Table is Parts, (only 5 columns of data)


Thanks,

Steve

[llkhoutx]

Assuming that your form recordssource is appropriatelt filtered

me.requery 

does wat you want.

[sesproul]

I'll try it out.


Thanks,