Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Greenville, SC

    Unanswered: Leaving my subform

    I need to find some code that would make this procecss easy.
    I have a form (WorkOrder) with a subform (FloorType). I use tab order which works fine into my subform (It is continious, not a datasheet). I then try to exit or tab out and it will not go out. Is there code i can write to get me out. For example lets say I enter text in amount, unit of measurement, Floor type and then I go to the next blank row and go to Floor Type and exit back into my form.

    Amount UOM Floor Type
    1300 SF MMA SL TF AO
    364 LF Coves
    15 Bags SL FIller
    (Empty) (Empty) (Empty)

    When I get to the last empty under floor type, it just cycles back through the empty cells.
    I need some code if that last cell is empty take me back out to the form I was in!


    Gotta to do some code

  2. #2
    Join Date
    Jun 2002
    Mpls/St.Paul area
    tabbing is difficult with subforms.

    Manually, Ctl + tab is the way to get out.

    programmatically - you could have an event, on exit that would be something like the following. You'd have to play with the syntax

    if isnull(me.txtControlA) then
    end if

    where txtControlA is the control they are tabbing out of and txtControlB is the control they are tabbing to.
    This is the day the Lord has made, I will rejoice and be glad in it.

Posting Permissions

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