Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Posts
    47

    Unanswered: Data refresh on subform.

    Hi,

    I have a mainform which has a subform (sfrmCheckExchRate). The subform is bound to a query (qryCheckExchRate).

    I am not able to requery the subform from the main form. I tried using:

    Code:
        
          Me!sfrmqryCheckExchRate.Form!qryCheckExchRate.Requery
    ...but get the error:

    Cant find field qryCeckExchRate in your expression

    I tried using:
    Code:
        
          Me!sfrmqryCheckExchRate.Form!RecordSource.Requery
    Even this doesn't work.

    Can someone help me?

    Rgds

  2. #2
    Join Date
    Feb 2004
    Posts
    47
    Got it!

    This one worked...
    Code:
        Me!sfrmqryCheckExchRate.Form.Requery

Posting Permissions

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