Results 1 to 5 of 5

Thread: Tab Controls

  1. #1
    Join Date
    Apr 2004
    Posts
    182

    Unanswered: Tab Controls

    Hi
    I have two tabs on a form. I want one for viewing records and the other for adding records. The form source is a query. How can I get the Add Record form to load up blank (as if I had just pressed the new record button.)

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    You could put some code in the OnClick event of the tab to determine which tab has been selected. If it is the dataentry tab, you could use then create a new record.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Apr 2004
    Posts
    182
    Sorry Teddy I am a beginner to this coding lark. Is this the same code as the Add New code I currently hav behind my add button ?

  4. #4
    Join Date
    Nov 2003
    Location
    Sussex, England
    Posts
    404

    Unhappy Left() <> Left$()

    ??

    I thought they were, but just used in different contexts.....

  5. #5
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    Ryker: As Izy will explain, in great detail, whether you'd like him to or not, Left() should only be used when referencing a variant, left$() is much faster and reserved for static datatypes.
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

Posting Permissions

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