Hi there,
I know that there is a simple solution to my question, but I am having a brain block...
I created a DB to track users that have been trained in a new system and which module training sessions they attended. I have a Training table that collects the Name, Practice Group, and the date that module training took place on.
I am trying to Search create a form where I can enter all or part of the name, and/or the Practice Group, and/or the Date of module training. I created a query that works when I enter the parameters. I want to connect the query to the form, have the info from the form populate the query parameters and return the information in a subform.
My FindQ Query is this:
I want this query to be called when I click Search on my Search form.
In my search form, I want Group to be a dropdown box. (I have a seperate table that holds the various groups that users can belong to.) MedChart, Pt Lists, and MedHist are all dates.
Any help is greatly appreciated. I did this several years ago, but I cannot access the DB that created the search on.
Thanks,
Silvia
I know that there is a simple solution to my question, but I am having a brain block...
I created a DB to track users that have been trained in a new system and which module training sessions they attended. I have a Training table that collects the Name, Practice Group, and the date that module training took place on.
I am trying to Search create a form where I can enter all or part of the name, and/or the Practice Group, and/or the Date of module training. I created a query that works when I enter the parameters. I want to connect the query to the form, have the info from the form populate the query parameters and return the information in a subform.
My FindQ Query is this:
Code:
SELECT Training.Name, Training.Group, Training.MedChart, Training.[Pt Lists], Training.MedHist
FROM Training
WHERE
(([Training].[Name] Like [Forms]![Frm_Find]![Name] & "*") Or ([Forms]![Frm_Find]![Name] Is Null))
AND (([Training].[Group]=[Forms]![Frm_SearchAttempt_Main]![Group]) Or ([Forms]![Frm_SearchAttempt_Main]![Group] Is Null))
And (([Training].[MedChart]=[Forms]![Frm_Find]![cldMedChart]) Or ([Forms]![Frm_Find]![cldMedChart] Is Null))
And (([Training].[Pt Lists]=[Forms]![Frm_Find]![cldPt Lists]) Or ([Forms]![Frm_Find]![cldPt Lists] Is Null))
And (([Training].[MedHist]=[Forms]![Frm_Find]![cldMedHist]) Or ([Forms]![Frm_Find]![cldMedHist] Is Null)) ;
In my search form, I want Group to be a dropdown box. (I have a seperate table that holds the various groups that users can belong to.) MedChart, Pt Lists, and MedHist are all dates.
Any help is greatly appreciated. I did this several years ago, but I cannot access the DB that created the search on.
Thanks,
Silvia