General information
Category:
Forms & Form designer
>Hello all! I’ve got a Grid question. I have a grid on a form displaying records from a SQL SELECT cursor. I have a check box on the form to reload the cursor based on a logical field in the source dbf. When I reload the cursor and refresh the grid, no data shows up in the grid. I checked the cursor and it does have records in it. Why won’t the grid show the new records? TIA!
Try this before running the code for recreate your cursor
Thisform.MyGrid.RecordSource = " "
Select * from mydata into cursor mycursor
Thisform.MyGrid.RecordSource = "mycursor"
The grid will show data and all header and other properties will be saved
Previous
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