C# winform access database search multi datagrid for date

Happy New Year to all,

I have a winform with 7 tabs (Tab Control) 6 of them have a datagrid with different information. The 7th tab has all the datagrid on it.

I need to enter a date on the 7th tab that will retrieve all information from that date for each grid button click. The Access database has 6 tables, the code is as simple as it gets to store information.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Shift_End_Report
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'shift_End_Report_3DataSet.Restriction_Accommodation' table. You can move, or remove it, as needed.
this.restriction_AccommodationTableAdapter.Fill(this.shift_End_Report_3DataSet.Restriction_Accommodation);
// TODO: This line of code loads data into the 'shift_End_Report_3DataSet.Open_Part_Issues' table. You can move, or remove it, as needed.
this.open_Part_IssuesTableAdapter.Fill(this.shift_End_Report_3DataSet.Open_Part_Issues);
// TODO: This line of code loads data into the 'shift_End_Report_3DataSet.SSAR' table. You can move, or remove it, as needed.
this.sSARTableAdapter.Fill(this.shift_End_Report_3DataSet.SSAR);
// TODO: This line of code loads data into the 'shift_End_Report_3DataSet.Hot_Calls' table. You can move, or remove it, as needed.
this.hot_CallsTableAdapter.Fill(this.shift_End_Report_3DataSet.Hot_Calls);
// TODO: This line of code loads data into the 'shift_End_Report_3DataSet.Attendance' table. You can move, or remove it, as needed.
this.attendanceTableAdapter.Fill(this.shift_End_Report_3DataSet.Attendance);
// TODO: This line of code loads data into the 'shift_End_Report_3DataSet.Part_Shortage' table. You can move, or remove it, as needed.
this.part_ShortageTableAdapter.Fill(this.shift_End_Report_3DataSet.Part_Shortage);
}
#region Part Shortage Buttons
private void btn_PS_Add_Click(object sender, EventArgs e)
{
this.partShortageBindingSource.AddNew();
}
private void btn_PS_Save_Click(object sender, EventArgs e)
{
this.Validate();
this.partShortageBindingSource.EndEdit();
this.part_ShortageTableAdapter.Update(this.shift_End_Report_3DataSet);
this.part_ShortageTableAdapter.Fill(this.shift_End_Report_3DataSet.Part_Shortage);
}
private void btn_PS_Next_Click(object sender, EventArgs e)
{
this.partShortageBindingSource.MoveNext();
}
private void btn_PS_Previous_Click(object sender, EventArgs e)
{
this.partShortageBindingSource.MovePrevious();
}
private void btn_PS_Delete_Click(object sender, EventArgs e)
{
this.partShortageBindingSource.RemoveCurrent();
}
private void btn_PS_Exit_Click(object sender, EventArgs e)
{
var result = MessageBox.Show("Are you sure you would like to exit?", "Closing Program",
MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
Application.Exit();
}
#endregion
}
#region Attendance Buttons
#endregion
#region Hot Sheet Button
#endregion
}
#region SSAR Buttons
#endregion
}
#region Open Part Button
#endregion
}
#region Restriction Buttons
#endregion
}
private void btn_Date_Click(object sender, EventArgs e)
{
}
}
}