Form problem

[ionutdinulescu]

I have a form on which I want to display only the fields of a single record. How can I dynamically change the query string of this form ?
I also tried to use the .Find method, which works Ok, but the user can accidentally step to the next record, by pressing the tab key.

 

[PHV]

Take a look at the Filter and FilterOn properties of the form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[ionutdinulescu]

Thanks, this partially helped. But now the problem is that if I press TAB on the last control on the form, It moves to the (Autonumber) record (the last one). I tried to use the OnCurrent event to check if I am on EOF then move prev, but doesn't work.

 

[PHV]

Take a look at the Cycle property of the Form object.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244