Results 1 to 5 of 5
  1. #1
    JamesP
    Guest

    Move to Record on subform (Access 97 )

    Help!
    Howdy!
    How can I get a subform to go to a specific record. The subForm is not linked.
    This one is really getting me on my nerves <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23> I would sure appreciate any help I can get.
    Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Move to Record on subform (Access 97 )

    Explain further what you're trying to do. If you just want to select a particular record in the subform, what are you going to use for the Find criteria? Is there a reason you haven't linked the subform to the parent? It's by far the easiest and fastest way to limit the records.
    Charlotte

  3. #3
    JamesP
    Guest

    Re: Move to Record on subform (Access 97 )

    He Charlotte
    Yes, There is a reason that I didn't link it and I have it actually working well with out the link. The trouble is that this records form this subform are related to the rest of the forms information on a Many to Many relationship which has an intersection table between them. I have the subform performing great until it has to respond to a certain update on the rest of the form. Even if I could get the silly thing to requery or reload I would be fine but every time I attempt to reference the subform from the main form it can not find the form.
    Arghhh!
    Thanks for you time Charlotte. :]

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Move to Record on subform (Access 97 )

    The way I handle many to many joins on a subform is to include the join table in the underlying query for the subform. That gives me a key for the one side of the join and I can use linking to avoid problem like you're describing.

    As for your referencing the subform, how are you doing that? It's probably a syntax error. You reference the actual subform from the main form using something like this:

    Me!Subformcontrol.Form

    If you just want to requery the subform, it's

    Me.!Subformcontrol.Requery

    But the correct syntax depends on what you're really trying to do.
    Charlotte

  5. #5
    JamesP
    Guest

    Re: Move to Record on subform (Access 97 )

    Thanks again Charlotte.

Posting Permissions

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