I have a table called “tbl_expense” and a form called “frm_expense_edit” that I use to edit the records in a table called “tbl_expense”. I am trying to set up a third form called “frm_find_all” that has fields from the “tbl_expense” table and they are the following: “office_id”, “employee_id”, “code_id”, and “date_of_expense” fields. The table has more fields but these are the fields I want the user to search the table on. I want the user to be able to select anyone or a combination of any field mentioned above to find the corresponding records in the “tbl_expense”. Some of the fields maybe blank depending on what record(s) the user is trying to find. The “date_of_expense” field should allow for a range date to be entered “from”, “to” date.
After inserting information for one or any other field they should be able to press a command button on the form “frm_find_all” that will open the form that I use for editing the table called “frm_expense_edit” with the correct records available for editing.
Could someone help me get started on the code that I would use behind the command button to filter the record(s) and bring up the edit form with the correct records?
After inserting information for one or any other field they should be able to press a command button on the form “frm_find_all” that will open the form that I use for editing the table called “frm_expense_edit” with the correct records available for editing.
Could someone help me get started on the code that I would use behind the command button to filter the record(s) and bring up the edit form with the correct records?