>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.
NoDataOnLoad is used for views - not tables so that won't help.
Using a parameterised view is one solution to your problem.
Cheers,
Jamie
Cheers,
Jamie