Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 221
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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