Results 1 to 6 of 6
  1. #1
    yagerlegi is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    29

    Change value of tab data using buttons

    I have an access form with combo box and the main data is Tab control. I want to add a button with the year so when you click on the year it can populate the data in the tab related to that year.
    Please help.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Please show/tell us what you have tried with what results.
    Do you have a sample of what you have and what you want to achieve?

    What exactly does this mean?
    the main data is Tab control

  3. #3
    yagerlegi is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    29
    Thank you for the quick reply. You can see the attached picClick image for larger version. 

Name:	Tab example.JPG 
Views:	7 
Size:	32.5 KB 
ID:	19700

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    Good start.
    What tables do you have? --that's where the data is stored.
    Somewhere you have info stored about Students and Staff, and it seems for several years.

    Please try to give readers "a description of the big picture" -- a 30,000 ft overview to put the pieces into context.
    Keep it simple, plain English --no jargon, and don't expect us to guess at what you might mean. Make it clear.

  5. #5
    yagerlegi is offline Novice
    Windows 7 32bit Access 2013
    Join Date
    Oct 2014
    Posts
    29
    Sorry, If I'm not speaking english.. Yes, I do have the data in a table.
    The question is what VBA code can I use to filter the data when the user select the button. Currently the data in tab can be populated based on the data from combo box, I would like to change it based on the button selected.

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    What have you tried? Can you show us some code?
    Please show us your relationships window as a jpg based on a PrintScreen/capture.

    Is this what you're looking for?

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

Similar Threads

  1. change color of a buttons
    By azhar2006 in forum Forms
    Replies: 1
    Last Post: 10-29-2014, 06:15 AM
  2. Replies: 16
    Last Post: 02-13-2014, 05:26 PM
  3. Replies: 6
    Last Post: 12-04-2013, 07:00 PM
  4. Replies: 1
    Last Post: 08-15-2013, 08:12 PM
  5. Replies: 1
    Last Post: 06-16-2012, 02:50 PM

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