Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 219
  • Last Modified:

clearing a dbgrid bound to a record source

I am using a bound dbgrid in a form which is fetching multiple data rows and displaying it into the grid. But when I want to refresh it - there is no command available to refresh and putting null values into the grid also does not solve the purpose - I want to get only one blank row when the form gets loaded - any solution to this problem - My thanks are due in advance.
0
abhijitbanerjee
Asked:
abhijitbanerjee
1 Solution
 
martiCommented:
After bounding the grid to a data control, set DatabaseName property of the data control to ""
On:
Private Sub Form_Click()
   
    Data1.DatabaseName = "C:\\DB\Diction.mdb"    '<- Your DB here
    Data1.Refresh
   
End Sub

0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now