Results 1 to 5 of 5

Thread: show no records

  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: show no records

    I have a subform on an unbound form. When I open the form; the subform is clear until I enter something in a txtbox to query the subform. But when I clear the txtbox the subform doe not clear also. I want the subform to clear all records when I hit the clear button. I tried:

    Code:
    Me.sfrmCustSearch.Form.Requery
    This just refresh the data does not clear records. I tried a couple of other things but no joy. Open to suggestions

  2. #2
    Join Date
    Mar 2009
    Posts
    5,442
    Provided Answers: 14
    Quote Originally Posted by slimjen View Post
    the subform is clear until I enter something in a txtbox to query the subform.
    What's the code in use to supply data to the subform?
    Have a nice day!

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    what you could do is pace some code int he parent forms no data event then did what you wanted

    im guessign you have to force the subform to repaint
    I'd rather be riding on the Tiger 800 or the Norton

  4. #4
    Join Date
    Jul 2004
    Posts
    214
    Quote Originally Posted by Sinndho View Post
    What's the code in use to supply data to the subform?
    I use a select query and on the filter load of the form is cust_id = null

  5. #5
    Join Date
    Jul 2004
    Posts
    214
    Quote Originally Posted by healdem View Post
    what you could do is pace some code int he parent forms no data event then did what you wanted

    im guessign you have to force the subform to repaint
    repaint rather than requery? What code suggested?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •