F
fapa via AccessMonster.com
Hi there
I've been told that it's possible to create filtered queries and assign them
to different buttons on a parent form. The aim of doing so, would allows the
form to be more customised.
I'm trying to do this however im having alot of trouble.
I have a form (frm_employee_records) and a subfrom (frm_employee_subform)
that displays a record of all the employees within the database.
I'm trying to create filters that allow the user to customise the records -
for instance, showing the employees with the highest salary/lowest.
The method in which i aim to do this is through buttons. When a user clicks
on a button, the form is filtered to show their answer.
The buttons are:
Highest Salary Employees
Lowest Salary Employees
First Start Date Employees
Lowest Start Date Employees
I've create queries to do this however im not sure how to assign them to the
buttons. I'm told i must change the recordsource and direct each button to
its query however im finding this reeally HARD!
can someone please help! Im trying to find the method in how to do this!
thaaaanks!
I've been told that it's possible to create filtered queries and assign them
to different buttons on a parent form. The aim of doing so, would allows the
form to be more customised.
I'm trying to do this however im having alot of trouble.
I have a form (frm_employee_records) and a subfrom (frm_employee_subform)
that displays a record of all the employees within the database.
I'm trying to create filters that allow the user to customise the records -
for instance, showing the employees with the highest salary/lowest.
The method in which i aim to do this is through buttons. When a user clicks
on a button, the form is filtered to show their answer.
The buttons are:
Highest Salary Employees
Lowest Salary Employees
First Start Date Employees
Lowest Start Date Employees
I've create queries to do this however im not sure how to assign them to the
buttons. I'm told i must change the recordsource and direct each button to
its query however im finding this reeally HARD!
can someone please help! Im trying to find the method in how to do this!
thaaaanks!