Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2005
    Posts
    68

    Unanswered: form with a subdatasheet

    i am trying to find the event that i can use to make the sub data sheet the active sheet the moment it is opened. i have tried both sides of the form, from the parent subform control's enter event to the subform's field on enter event (i set the focus to this field). i can not seem to find an event that will set the focus directly to the subform. the current form is still the parent form until i move in the subdata sheet. if anyone has had a similar problem please let me know.
    thanks

  2. #2
    Join Date
    Jun 2004
    Posts
    50
    did you try setting the focus to the subform in the main form's load or open event?
    Last edited by Monk010100; 02-05-05 at 10:16.
    Monk
    The person who confesses ignorance shows it once; the person who conceals it shows it many times.

  3. #3
    Join Date
    Sep 2004
    Location
    Tampa, FL
    Posts
    520
    You can use setfocus on the name of the subform and focus will go to tab 0 of the subform.
    ie.. Me.subformname.setfocus
    Darasen

  4. #4
    Join Date
    Jan 2005
    Posts
    68

    thanks

    thanks for the advice. sometimes it seems like the harder you work on something the harder it is to see the obvious solution.

Posting Permissions

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