Results 1 to 4 of 4

Thread: Recordsource

  1. #1
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42

    Unanswered: Recordsource

    Hi,

    It is possible to say in VBA:

    me.form_x.recordsource = qryQuery

    I mean, is it possible to say in VBA that the recordsource is a query?

    Thx for your help

  2. #2
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    Yes it is.

    you'll need to refresh your objects on the form.

    If you give some more details, I'll type some lines up for you.

    ~Ken

    Like:

    Me.RecordSource = "SELECT Raw_Clean_RM_KH.* FROM Raw_Clean_RM_KH;"
    Me.Recalc
    Last edited by Ken_Hart; 03-04-04 at 04:43.

  3. #3
    Join Date
    Dec 2003
    Location
    Belgium
    Posts
    42
    thx ken,

    it's the me.recalc that was missing in my code,

    i appreciate your help!

    greetz

  4. #4
    Join Date
    Feb 2004
    Location
    Dorset UK
    Posts
    147
    If you have other objects use myobject.requery

    But recalc seems to do all/most.

    If I can help any more, let me know.

    Ken

Posting Permissions

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