Hi, I was just wondering if the criteria in a query or a search/filter can automatically put the contents of whatever is in a textbox (text) as the filter and so it will display only results with whatever is in the textbox, in the record.
I have a doctors patient surgery and In the "Patient Records" Form I have all of their information etc. I can click through the records and different information coms up for each person as I want it to, including their current medication. I also have a form called "Drug reference" and That is the same thing except with drugs. So I can click through the records and each drug will come up with its own information.
As I stated above. Id like to be able to click on the "current medication" box in my "Patient Records" form, of which there are 7 and when I click on the box it loads up the Drug reference Form at the correct record. I.e so if a patient is on "benzol" and I click on the text box with that information in it. The "Drug Reference" form will load up at the correct record- Benzol.
Please Please help me in any way. I feel I might have to do it in a query, and I don't want to use a combo box for each medication that they are on since I will then have 7 combo boxes on my form and when I would click on them they would have just 1 record in, which is a bit silly.
I have a doctors patient surgery and In the "Patient Records" Form I have all of their information etc. I can click through the records and different information coms up for each person as I want it to, including their current medication. I also have a form called "Drug reference" and That is the same thing except with drugs. So I can click through the records and each drug will come up with its own information.
As I stated above. Id like to be able to click on the "current medication" box in my "Patient Records" form, of which there are 7 and when I click on the box it loads up the Drug reference Form at the correct record. I.e so if a patient is on "benzol" and I click on the text box with that information in it. The "Drug Reference" form will load up at the correct record- Benzol.
Please Please help me in any way. I feel I might have to do it in a query, and I don't want to use a combo box for each medication that they are on since I will then have 7 combo boxes on my form and when I would click on them they would have just 1 record in, which is a bit silly.