Results 1 to 2 of 2

Thread: Form with Tabs

  1. #1
    Join Date
    Oct 2007

    Question Unanswered: Form with Tabs

    Let me begin with the fact that when it comes to writing script, I am a babe in the woods. I have a form with 5 tabs. I need a script that ensures that "Lease Number" (on the main form) is always showing at the top of the screen no matter what tab I click on. Can any of you experts out there assist me? I would be much grateful!!

  2. #2
    Join Date
    Dec 2004
    Madison, WI
    The question is where is your Lease Number field stored and what is the recordsource for your main form?

    You need to tell us a little bit about how your main form and tables are setup. Is your main form's recordsource based on your main data table? If so, is Lease Number a field in your main data table? If not, why is it in each of the relational tables?

    Do your tabs have subforms in them which might be based on relational tables to the main data table?

    You won't need a script to show the Lease Number on the main form. You can set the sourceobject of a field on your main form to equal the Lease Number field wherever it's located.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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