Hi all,
This one is way to complex for me to work out.
Presently I have a search form (frm_Search) which is accessible via the Switchboard. I want to be able to search for records within frm_Argument.
I've created a many-to-many relationship between tbl_Argument and fields; fld_Structure, fld_System, fld_Component, fld_Substance which are based on their respected tables. I adjust how the fields and arguments from frm_Argument are linked via a junction table/form.
I want to be able to search using the fields above on frm_Search using comboboxes to filter frm_Argument to the records which are joint to each particular field.
The problem is that the fields can only be shown within a sub-form on frm_Argument because they are not within tbl_Argument (unless I can create a bound lookup somehow?). It means that it will be difficult to filter the form from a seperate form unless you can link to the subform?
Once that has been worked out I'd also like to be able to select the 4 fields (based on seperate comboboxes) on frm_Search to filter the records down as much as possible rather than just using one combobox. Also on frm_Search I'd want to use a command button once the combobox items have been selected to open frm_Argument with the filtered results.
I have no idea where to start.
Thank you for any assistance and I'm sorry if this isn't obvious enough,
Leigh