Clownfish1980m
Clownfish8182m
- Local time
- Yesterday, 19:59
- Joined
- Sep 18, 2009
- Messages
- 40
I have created a database that is going to be used to look up medications to determine if donors are suitable for donating. I have a form called “Medication Search”. On this form I have a combo box that allows the user to select the medication either by a drop down or by typing the first letters and then selecting it. The problem I am having is it doesn’t show the correct information. To resolve this, I would like to have it where the user selects the medication and then click on a command button to show the report for that drug only. I created a command button to view report but it shows all medications and not the one selected. I am also open to other suggestions for searching. Ken