Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    USA
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Tab out of subform (A2K)

    Ok, I have a sub form where people need to enter information that deals with the information on the main form. These populate two different tables for various reasons. Anyway how do I tab out of the sub form? When i fill the last box of information on the sub form the tab sequence just allow me to tab out and I don't know how to get it to do so. Thanks for the help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Tab out of subform (A2K)

    Brandon,

    Microsoft has a KB article on precisely this question.

    Keep fit!
    Hans

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    USA
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Tab out of subform (A2K)

    Thanks Hans. Access can be such a pain sometimes. <img src=/S/clapping.gif border=0 alt=clapping width=19 height=23> I'll be keeping fit for as long as I can walk. <img src=/S/heavy.gif border=0 alt=heavy width=40 height=34>

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

    Re: Tab out of subform (A2K)

    There's another method that I prefer. I put a 0 width unbound, locked textbox on the subform at the end of the Detail section tab order. In the Enter event of that control, I put code to set the focus to the specific control on the parent form that I want to tab to. It's very reliable because the textbox is there for no other purpose than "tabbing" back to the parent form so it doesn't have any possibly conflicting events to deal with.
    Charlotte

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

    Re: Foreign key not populating automatically (A2K)

    Does this have anything at all to do with tabbing out of the subform? If not, it might be better to start a new thread, or at least change the subject line. And please explain which form/subform you're having the problem with. I can't tell if the publication record key and the record management key are even on the same form so it's pretty difficult to say what might be wrong.
    Charlotte

  6. #6
    2 Star Lounger
    Join Date
    May 2002
    Location
    USA
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Key doesn't fill

    now a different problem. It works at the beginning and then stops. I have the subform and main form linked by the primary key field. Now what should happen when I enter the key number for the publication record the record management key number should automatically fill. Now it worked when I first started entering my data, but now it just stopped working. WHAT"S WRONG WITH IT!! <img src=/S/scream.gif border=0 alt=scream width=15 height=15> Sorry I'm getting mad at this thing. <img src=/S/hairout.gif border=0 alt=hairout width=31 height=23>

  7. #7
    2 Star Lounger
    Join Date
    May 2002
    Location
    USA
    Posts
    190
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Foreign key not populating automatically (A2K)

    Well here is a better description. I have an Item # that I need to enter for both my publications table and my Records Management table. When I put in the subform I link the two by using the Item# since it is the primary key. They need to be the same because this is how information will be looked up. Anyway the Item # on the Records Management subform should fill as soon as I tab out of the Item # on the Publication main form. It works for a while and then just quits. I don't know why, and I have tried numerous times to figure out why it has been doing that. thanks for the help.

Posting Permissions

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