I have never done that with a table but with local views works.
Create a local view with a parameter
Initialize the parameter on the data enviroment "BeforeOpenTable" event
Ie
cKey = “”
and on the valid of the key field
cKey = this.value
requery()
>do form myform
>Set nodataonload to true.
>When form comes up 1st record is displayed ANYWAY.
>
>I do not want recs displayed until the user selects one. user is in key field and code i have placed in the valid event will find the record to display.
>
>There are no buttons on the form if that matters.
>
>The form is being called from a 2.6 style program (prg) if that matters.
>
>Very basic form. User enters key value, find occurs and if found, the rec is displayed otherwise error is displayed. if the rec is found user may enter a value in only 1 field of same record. User saves. Start all over.
B.D.H.