Your results form must be the data entry form? My query form includes a grid, allowing the user to see the results, but only return one record (PK) to the DE form. I suppose I can show the grid, and set the properties after the cursor is returned.
Thanks for the help
John
>
>At first there is a dead grid on the results form with no RecordSource or any other proerties defined for the grid. Of course the user never sees this because in the INIT of the form, I call my Query form if no Cursor exists. My Query form is modal and has a private DS. From the INIT of the results form, I issue a -- DO FORM SQLQuery to lcSQL. If lcSQL comes back empty, I return .F. and the form never shows. Otherwise, I just start populating the grid properties as needed. Generically, I just show every field in the cursor except my PK field. Since I always name my PK field KeyID in all my tables, this is easy to do.
>
>On the results form, I also have a QUERY button so the user can always do another query.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only