General information
Category:
Coding, syntax & commands
Thanks Marcia That did it - works great. This is my first venture with views and grids and you have been a big help. From past practices, I had gotten in the habit of alway setting the record source from code as I usually had tables as the recordsource and used this to combat the blank grids that the table closing or losing focus created.
Thanks again.
Gaylen
>Hi Gaylen.
>
>It is a parameterized view. In the load event I set up some dummy variable for the view and open the view. I then reset the variables based on the parameters I send over from the calling program, so I only see the records which meet the criteria from the calling program.
>
>You can USE the view NODATA. As long as you do this in the form's load or in the form's DE, you can still specify the view as the grid's RecordSource in the property sheet of the form designer. Then, in the form's Init(), you just REQUERY() the view based on the parameters you receive from the calling form.
>
>This will not close the view, thereby resetting the grid.
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