Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    63

    Exclamation Unanswered: Combo Box AfterUdate

    I'm having problem changing data in my subform based on main form selected id from cboCustID.

    I have frmMain and Subfrm which are link ok.....frmMain has cboCustID when ever user chages the value in cboCustID the data in subfrm doesn't chage...I try writing code in AfterUpdate event of cboCustId but i sitll can't figure out what's going on.

    Set rs = Me.Recordset.Clone
    rs.FindFirst "[CustID] = '" & Me![CboCustID] & "'"
    Me.Bookmark = rs.BookmarkMe.Recordset.Clone

  2. #2
    Join Date
    Sep 2003
    Posts
    228
    I'm just taking a stab here, I'm new.
    The syntax I'm used to seeing for referencing a control on a subform is:

    [Forms]![MainForm]![SubForm].[Form]![ControlName]

    Maybe if you replaced some "Me's" with more explicit references you might have different results...

  3. #3
    Join Date
    May 2004
    Posts
    63
    I don't think i have link my forms right. My main form PK is CustID and its also reference in Subfrom as FK. So how can i link my main form to subform ?

Posting Permissions

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