Results 1 to 4 of 4
  1. #1
    nogames627 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    6

    Differentiate Task Type in a Form using tab control and one source table.

    I am converting the Tasks Template in 2010. I have all of my tasks in one source table I have labeled them as a correspondence or an Award. I have added a tab control page on the Task Details form and I would like to make it so you can only enter Awards on the Awards Tab and Correspondence on the correspondence tab. I have made the form a Data entry form and I was planning on inserting this on a Navigation form if this is possible. I am a beginner who has little to no knowledge of VBA Modules. Can anyone advise me on a way to do this? Thank you so much for any assistance you can provide.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    My first question is Why?

    This would involve two sets of controls bound to the same fields, probably have to build a form for each category and setup as subforms on the Tab control pages. Or using unbound form and controls.

    I think a navigation form will accept a Tab control but I don't like and don't use navigation form.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    nogames627 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2013
    Posts
    6
    I thought that would be easier than building the two forms. The data types are the only things that are different. Every other piece of data on the form is exactly the same. Do you have an idea on a better way to do this. I am open to any suggestions. I just want to make sure it is user friendly. Anything you can provide is greatly appreciated.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    The only other approach is a conventional form with a combobox to select the category.

    I just remembered I have done something like what you described and I used subforms on a Tab control. A textbox DefaultValue property is set for the category and it is not visible to the user.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 08-13-2013, 03:54 PM
  2. Replies: 1
    Last Post: 04-23-2013, 03:35 PM
  3. Control Source on Form Reading Value in Table
    By hammer187 in forum Forms
    Replies: 1
    Last Post: 10-23-2012, 02:43 PM
  4. Replies: 5
    Last Post: 06-25-2012, 02:06 PM
  5. Should forms use a table or query as their control source?
    By cheyanne in forum Database Design
    Replies: 2
    Last Post: 05-30-2012, 04:00 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums