Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    subform not synching (a2k)

    I've got an Order form that opens via a cmd button on the Consumer form. The Order form opens to a blank record and then pulls the value in the txtConsumerID from the main form into it's own txtConsumerID. The underlying tables are linked by lngConsumerID.

    I've placed an Address subform on the Orders form. The link between the main form and the subform is lngConsumerID. However the subform is opening blank. I tried requerying the main form in the After_Update of the txtConsumerID, but it's still blank.

    I use the same Order form witht the data entry switch off to edit existing orders. The address subform works just fine on it.

    What am I missing?

    E

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: subform not synching (a2k)

    You say that: "The link between the main form and the subform is lngConsumerID" but does this mean that you have explicitly set the master and child links between the forms?
    Regards
    John



  3. #3
    3 Star Lounger
    Join Date
    Jul 2002
    Location
    Cedar Falls, Iowa, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: subform not synching (a2k)

    Problem solved. At the point where I was requerying, the record had not yet been created. Set the requery to another control and all was well.

    E

Posting Permissions

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