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.
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.
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
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.
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.
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?