Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: Reference subform recordset from main form

    This one OUGHT to be easy, but I've gone blank once again.. lunch was hard on me :-)

    Dim udvalg As ADODB.Recordset
    Set udvalg = New ADODB.Recordset

    Dim forbindelse As ADODB.Connection
    Set forbindelse = New ADODB.Connection

    Dim SQL As String

    SQL = "SELECT * FROM md_vw_trackoplysninger WHERE MUSAnummer = " & Str(md_vw_trackoplysninger.Value)

    forbindelse.Open "provider=SQLOLEDB;Data source=DB;initial catalog=UDV;User ID=AccessBruger;Password="

    Set udvalg.ActiveConnection = forbindelse
    udvalg.Source = SQL
    udvalg.Locktype = adLockReadOnly
    udvalg.CursorLocation = adUseClient

    Set Me.subform_udvalg. here's my problem, how to reference the recordset property
    Set udvalg = Nothing
    Set forbindelse = Nothing

    Its pretty straight forward, a button on my main form is set to create a SQL string with a where clause based on a textbox. Once the where value has been fetched, its to create an ADO sql-server recordset, and pass it on to my subforms recordset.

    Doing a "me.recordset" on the subforms is easy, but I never can get the object and property model right.

    Thanks in advance


    EDIT: Ah, got it: Set Me.subform_udvalg.Form.Recordset = udvalg
    Last edited by Trinsan; 01-24-06 at 09:21.
    IT squid: networks, servers, firewalls, routers and I dabble a little with SQL-server and Access as well....

  2. #2
    Join Date
    Nov 2003
    Ottawa, Ontario, CANADA
    The general expression to reference subform recordset from main form is as follows:

    forms!MyMainForm!MySubForm.Form!MyControlOnMySubFo rm

    Hope this helps..

Posting Permissions

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